The Variant data type, while inefficient, is necessary in many situations. You can create a Variant Array using the Array function like this
vaTest = Array(1, 2, 3)
You can also make the elements of your array arrays themselves, nested arrays if you will.
vaTest = Array(Array(1, 2, 3), Array(4, 5, 6))
This bit of code will produce 2 in the Immediate Window. The syntax for accessing the nested array reads “Get the second element of the array that is the first element of vaTest. vaTest(0) accesses the first element of vaTest which is an array and (1) accesses the second element of that array.