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