Category - Information

List of user defined functions

CELLTYPEReturns the type of value that is contained in a particular cell.
COLUMNWIDTHReturns the column width of the active cell.
COMPUTERNAMEReturns the full computer name of where the code is running.
EXCELDIRReturns the various folder locations that Excel uses including installation and startup.
FILEEXISTSReturns whether a particular file exists.
FOLDEREXISTSReturns whether a particular folder exists.
ISBETWEENReturns whether a particular cell value is between a range.
ISBOLDReturns whether a particular cell has bold formatting applied.
ISINTEGERReturns whether a particular number is an integer number.
ISITALICReturns whether a particular cell has italic formatting applied.
ISLOCKEDReturns whether a particular cell is locked or not.
ISLOWERReturns whether a particular string is in lower case.
ISMERGEDReturns whether a particular cell is merged or not.
ISPRIMEReturns whether a particular number is a prime number.
ISPROPERReturns whether a particular string is in proper case.
ISUNDERLINEReturns whether a particular cell has underline formatting applied to it.
ISUPPERReturns whether a particular string is in upper case.
ISWRAPPEDReturns whether a particular cell has text wrap formatting applied.
LASTINCOLUMNReturns the last cell that contains data in a particular column.
LASTINROWReturns the last cell that contains data in a particular row.
ROWHEIGHTReturns the row height of the active cell.
USERNAMEReturns the application's user name or the domain username.
WORKBOOKFILEEXTENSIONReturns the file extension
WORKBOOKFILENAMEReturns the name of the workbook (with or without file extension)
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 a worksheet in the active workbook given an index position.
CELLTYPE
Returns the type of value that is contained in a particular cell.
COLUMNWIDTH
Returns the column width of the active cell.
COMPUTERNAME
Returns the full computer name of where the code is running.
EXCELDIR
Returns the various folder locations that Excel uses including installation and startup.
FILEEXISTS
Returns whether a particular file exists.
FOLDEREXISTS
Returns whether a particular folder exists.
ISBETWEEN
Returns whether a particular cell value is between a range.
ISBOLD
Returns whether a particular cell has bold formatting applied.
ISINTEGER
Returns whether a particular number is an integer number.
ISITALIC
Returns whether a particular cell has italic formatting applied.
ISLOCKED
Returns whether a particular cell is locked or not.
ISLOWER
Returns whether a particular string is in lower case.
ISMERGED
Returns whether a particular cell is merged or not.
ISPRIME
Returns whether a particular number is a prime number.
ISPROPER
Returns whether a particular string is in proper case.
ISUNDERLINE
Returns whether a particular cell has underline formatting applied to it.
ISUPPER
Returns whether a particular string is in upper case.
ISWRAPPED
Returns whether a particular cell has text wrap formatting applied.
LASTINCOLUMN
Returns the last cell that contains data in a particular column.
LASTINROW
Returns the last cell that contains data in a particular row.
ROWHEIGHT
Returns the row height of the active cell.
USERNAME
Returns the application's user name or the domain username.
WORKBOOKFILEEXTENSION
Returns the file extension
WORKBOOKFILENAME
Returns the name of the workbook (with or without file extension)
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 a worksheet in the active workbook given an index position.

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