Category - Information

FILEEXISTSReturns whether a particular file exists.
ISBOLDReturns whether a particular cell has been formatted in bold.
LASTINCOLUMNReturns the last cell that contains data in a particular column.
LASTINROWReturns the last cell that contains data in a particular row.
USERNAMEReturns the application's user name or the domain username.
WORKBOOKFILENAMEReturns the file name of the active workbook.
WORKBOOKPATHReturns the folder path of the active workbook.
WORKBOOKPATHFILENAMEReturns the folder path and file name of the active workbook.
WORKBOOKPROPERTIESReturns a particular workbook property of the active workbook.
WORKSHEETNAMEReturns the name of the worksheet in a given position.
FILEEXISTS
Returns whether a particular file exists.
ISBOLD
Returns whether a particular cell has been formatted in bold.
LASTINCOLUMN
Returns the last cell that contains data in a particular column.
LASTINROW
Returns the last cell that contains data in a particular row.
USERNAME
Returns the application's user name or the domain username.
WORKBOOKFILENAME
Returns the file name of the active workbook.
WORKBOOKPATH
Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME
Returns the folder path and file name of the active workbook.
WORKBOOKPROPERTIES
Returns a particular workbook property of the active workbook.
WORKSHEETNAME
Returns the name of the worksheet in a given position.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext