Kevin wrote:
Thanks Bill.
I have 524k now. The problem is the error could occur during a
deadline and I don't have time to go add more then. How do you know
when you have enough?
Hopefully someone else will chime in here. I've never run into your
problem in a machine with that much RAM. Here is a link to some old
information on memory limitations in Excel though:
http://groups-beta.google.com/group/...re.p ipex.net
This also has some info on optimizing memory usage:
http://www.mvps.org/dmcritchie/excel/slowresp.htm
Sorry I can't help.
Bill