The default value is 0. Furthermore, string data types can be either fixed or variable in length. Variant is a special data type capable of storing any of the data types in the above table. Unless you explicitly declare your variable as one of the other data types VBA will store it as a variant . The default value is Empty .
Object contains a reference to the memory address of an object.
When declaring objects it is better to use a specific object type such as cell or range rather than the generic object type which uses late binding. The default value is Empty . Array is a collection of variable called elements that share the same name and data type. The default value is equal to the default value of the data type used in the array declaration. Type Conversion VBA provides several conversion functions for converting one data type to another.