VBA memory

J

Jeff

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
 
B

Bob Phillips

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)
 
Top