Out of memory

[fobinus]

Hello,

I am working on a macro with excel, which crunches a lot of data and
plots graphs.

I am running into issues with Out of memory problems. I am currently
using 512 MB Ram computer with Excel 2000.

Any suggestions or pointers to solve this problem would be appreciated.
Thanks.

 

[Nick Hodge]

The amount of physical memory you have is of little consequence as Excel
only uses it's own pool.

You may wish to check this out?

http://www.decisionmodels.com/memlimitsc.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)