Whats the difference between a Variant array and an array of Variants?
A Variant is a special data type that can contain any kind of data — a single value, or an array of values (that is, a Variant array). The code below creates a Variant that contains an array. Dim X as Variant X = Array(30, 40, 50) A normal array can contain items of a specified data type, including non-typed Variants. The statement below creates an array that consists of 12 Variants. Dim X (0 to 2) as Variant Although a Variant containing an array is conceptually different from an array whose elements are of type Variant, the array elements are accessed in the same way.
