Category - Information

List of user defined functions

CELLTYPEReturns the type of value that is contained in a particular cell.
COMPUTERNAMEReturns the full computer name of where the code is running.
FORMULAGETReturns the formula from a particular cell.
ISBOLDReturns whether a particular cell has bold formatting applied.
ISDATEReturns whether a date is the first (or last) of a week, month or year.
ISFORMULAReturns whether a particular cell contains a formula.
ISINTEGERReturns whether a particular number is an integer number.
ISITALICReturns whether a particular cell has italic formatting applied.
ISLIKEReturns whether a particular string matches a certain pattern.
ISLOCKEDReturns whether a particular cell is locked or not.
ISLOWERReturns whether a particular string is in lower case.
ISMERGEDReturns whether a particular cell is merged or not.
ISPRIMEReturns whether a particular number is a prime number.
ISPROPERReturns whether a particular string is in proper case.
ISUNDERLINEReturns whether a particular cell has underline formatting applied to it.
ISUPPERReturns whether a particular string is in upper case.
ISWRAPPEDReturns whether a particular cell has text wrap formatting applied.
NUMBERFORMATGETReturns the number format used on a particular cell.
USERNAMEReturns the application's user name or the domain username.
WORKBOOKFILEEXTENSIONReturns the file extension
WORKBOOKFILENAMEReturns the name of the workbook (with or without file extension)
WORKBOOKPATHReturns the folder path of the active workbook.
WORKBOOKPATHFILENAMEReturns the folder path and file name of the active workbook.
WORKSHEETNAMEReturns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNTReturns 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