Excel Functions Information Functions

Information Functions

List of user defined functions

CELLTYPE	Returns the type of value that is contained in a particular cell.
COMPUTERNAME	Returns the full computer name of where the code is running.
FORMULAGET	Returns the formula from a particular cell.
ISBOLD	Returns whether a particular cell has bold formatting applied.
ISDATE	Returns whether a date is the first (or last) of a week, month or year.
ISFORMULA	Returns whether a particular cell contains a formula.
ISINTEGER	Returns whether a particular number is an integer number.
ISITALIC	Returns whether a particular cell has italic formatting applied.
ISLIKE	Returns whether a particular string matches a certain pattern.
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.
NUMBERFORMATGET	Returns the number format used on a particular 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.
WORKSHEETNAME	Returns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNT	Returns the total number of sheets in the active workbook.

CELLTYPE Returns the type of value that is contained in a particular cell.
COMPUTERNAME Returns the full computer name of where the code is running.
FORMULAGET Returns the formula from a particular cell.
ISBOLD Returns whether a particular cell has bold formatting applied.
ISDATE Returns whether a date is the first (or last) of a week, month or year.
ISFORMULA Returns whether a particular cell contains a formula.
ISINTEGER Returns whether a particular number is an integer number.
ISITALIC Returns whether a particular cell has italic formatting applied.
ISLIKE Returns whether a particular string matches a certain pattern.
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.
NUMBERFORMATGET Returns the number format used on a particular 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.
WORKSHEETNAME Returns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNT Returns the total number of sheets in the active workbook.