Category - Information

List of user defined functions

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.

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.