TYPENAME

TYPENAME(varname)

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

varname

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

REMARKS

* The string returned by this function is the class name.
* For more information, 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 learn.microsoft.com

Debug.Print TypeName("String")   '= "String"  
Debug.Print TypeName(1)          '= "Integer"  
Debug.Print TypeName(10.4)       '= "Double"  

Dim vVariant As Variant 
sVariant = CDec(10.5) 
Debug.Print TypeName(vVariant)   '= "Decimal"  

Dim sTemp As String 
Debug.Print TypeName(sTemp)      '= "String"  

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