VBA memory
 

Hi,

I am using excel 97.

I have declared an array

Dim array1(2500000,360,25) as double

are there any memory limitations in dealing with arrays?

Thanks

VBA memory
 

By my calculations that is circa 180Gb. I think you might struggle with
that.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jeff" wrote in message
...
Hi,

I am using excel 97.

I have declared an array

Dim array1(2500000,360,25) as double

are there any memory limitations in dealing with arrays?

Thanks