Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Misc functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - VarType function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Misc - VarType

Syntax:
=VarType(Value , Optional TypeText )

Description:
Returns the type of a variant value. Values in Excel cells are variants. With VarType you can determine whether the value is a text, a long, an integer, a boolean, etc.

Value : value to inspect
TypeText : Optional. When set to TRUE VarType will return a text indicating the type. Otherwise VarType will return a number.

Example:
=VarType(123)
=VarType(A1)

litLIB