#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 921
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to Shell and remove Excel from memory? alainB Excel Discussion (Misc queries) 3 August 2nd 06 04:16 PM
Excel 2003 memory issue ngenear11 Excel Discussion (Misc queries) 0 May 26th 06 04:28 PM
Out of memory? JENNYC Excel Discussion (Misc queries) 1 November 28th 05 10:58 PM
Memory Leak in Excel ofra Excel Discussion (Misc queries) 0 August 28th 05 02:20 PM
Worksheet Memory hog Lowkey Excel Discussion (Misc queries) 2 June 2nd 05 04:47 PM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"