VarType function returns

Returns an integer indicating the subtype of a variable.

The VarType function itself never returns a value to vbArray. VarType always adds some other values to indicate a particular type of array. The constant vbVariant is only returned with vbArray to indicate that the argument of the VarType function is an array of type Variant. For example, the return value of an integer array is vbInteger+vbArray, which is 8 194. If an object has a default attribute, VarType (object) returns the type of the object's default attribute?