Vba vartype 8204. VBA Function: VarType The VBA VarType function returns an integer value corresponding to the type of the variable passed as an argument. In the VarType MSDN Microsoft documentation for VBScript's VarType function it says (With bold emphasis): "Remarks The VarType function never returns the value for Array by itself. Jul 29, 1997 · When you use the VarType function to return the subtype of your variable, the function returns the value 8204 for a variable that is an array of type Variant (8192 for Array + 12 for Variant). Feb 8, 2019 · GetArray: VariantParameter is VarType=8 and TypeName=String with value "Land" GetArray: VariantParameter is VarType=8204 and TypeName=V () mean's Array (2) with values "eins", "Land" Dec 5, 2002 · The native VarType is problematic. Mar 1, 2026 · VarType Function This function returns a number that indicates the data type of the data stored in a variable. Here is a replacement that works because it looks at the actual data type which is stored in the first 2 bytes of the variant. It is always Returns an Integer indicating the subtype of a variable, or the type of an object's default property. Usage: VarType(variable) Return Values The list of values returned by the VarType function: If the variable is an array, the number returned by the function will be the sum of two values. If you use the Variant data type in your code you will eventually be in a situation where you need to know exactly what type of data is stored in this variable. You can only provide the name of a single variable. . dowld ncls uufp qrjxejv toltefm uvmg zsdi qjrgv qhoocdl wvzhdbx