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

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

While you are correct that you can declare your array as any data type you
want, your resulting array will use the same amount of memory as a variant.
The only difference is that the explicitly declared array will be more
efficient since the variable type will not need to be determined at run time.

In short whether it is an array of strings or a variant it is going to hold
the exact same data (an array of strings).
--
HTH...

Jim Thomlinson


"Per Jessen" wrote:

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

Hi Jim, not sure that's quite right

Sub foo()
Dim sArr(1 To 2) As String
Dim vArr(1 To 2) As Variant

Debug.Print VarPtr(sArr(2)) - VarPtr(sArr(1)) ' 4
Debug.Print VarPtr(vArr(2)) - VarPtr(vArr(1)) ' 16

End Sub

Regards,
Peter T


"Jim Thomlinson" wrote in message
...
While you are correct that you can declare your array as any data type you
want, your resulting array will use the same amount of memory as a
variant.
The only difference is that the explicitly declared array will be more
efficient since the variable type will not need to be determined at run
time.

In short whether it is an array of strings or a variant it is going to
hold
the exact same data (an array of strings).
--
HTH...

Jim Thomlinson


"Per Jessen" wrote:

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