VBA: Save data from SQL queery in an array.

Originally Posted by xlnitwit

Do you know how to use the Locals window in the VB editor? It will tell you the type, size and shape of the array.

I just googled it so I do now. It says TheArray is of type Variant. This webpage says the same: https://msdn.microsoft.com/en-us/lib.../ff194427.aspx because we have used GetRows