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 <ExcelMon...@discussions.microsoft.com>
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 <ExcelMon...@discussions.microsoft.com>
> 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" <James_Thomlinson@owfg-Re-Move-This-.com> wrote in message
news:52090637-BB99-4B4D-925A-(E-Mail Removed)...
> 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 <ExcelMon...@discussions.microsoft.com>
> > 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
> >
> >