
VBA Not Enough Memory Error
Hi
I have written some VBA Excel code to generate plots from data. Each plot is
generated by creating a new sheet in a workbook. After about 40 plots it
complains that there isn't enough memory. However when I look at the system,
there appears to be a lot of
memory available. I'm running Windows NT with
128 Megs of RAM, and the plots are fairly simple with about 10-20 points with
error bars.
Any ideas on where to look would be greatly appreciated.
Thanks
Tim
--
Tim Stelzer Voice: (217) 265-0758
267 Loomis Lab Fax: (217) 333-9819
Physics Department
Urbana IL 61801 http://web.hep.uiuc.edu/home/tstelzer