Information Functions

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.
USEDRANGEReturns the used range on the active worksheet.
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.
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.
USEDRANGE
Returns the used range on the active worksheet.
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.
WORKBOOKPROPERTIES
Returns a particular workbook property of the active workbook.
WORKSHEETNAME
Returns the name of the worksheet in a given position.

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