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.