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.
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.
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.