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.
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 partcular 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.
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 partcular workbook property of the active workbook.
WORKSHEETNAME
Returns the name of the worksheet in a given position.

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