On 5 Jun., 19:58, ExcelMonkey
wrote:
I am loading text into a large array dimensioned as a Variant. *Is this the
only way to dimension the Array? *I am wondering if I can dimension the array
in a less memory intensive manor?

Thanks

EM

Hi

Yes you can use the same types as with other variables.

Dim MyArray(10) as String

Regards,
Per