Category - Information
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. |
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext