TYPENAME(varname)

Returns the data type of the variable as a string (String).


varnameThe data type name, expression or variable (Object).

REMARKS
* The string returned by this function is the class name.
* For an illustrated example refer to the TypeName Function page.
* You can use the VARTYPE function to return a number indicating the data type.
* The equivalent .NET function is Microsoft.VisualBasic.Information.TypeName
* For the Microsoft documentation refer to docs.microsoft.com

TypeName("String") = "String" 
TypeName(1) = "Integer"
TypeName(10.4) = "Double"
TypeName(sTemp) = "String"

If TypeName(Application.Selection) = "Range" Then
End If

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top