Claus, try changing your printer to a Brothers Laser, even if you do not
have one installed. Some print drivers cause memory problems, especially HP
print drivers.
Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"Claus Zimmermann" wrote in message
...
Hi
I have a BAD memory leak when I copy a chart... even a blank chart to
another worksheet. It eventually causes excel to crash.
In my example, the sequence to crash excel was as follows:
- Copy Chart 5000 times (loop) - less times would work too, and
you'd
see the increase in private bytes as you go along
- Copy method of range class failed
- Clicked End button on debug message box
- Closed Excel
- Message: The picture is too large and will be truncated
- Excel.exe - Application error. The instruction at "0x300dc756"
referenced memory at "0x000000008". The memory could not be read.
I'm using Excel 2000 sp3
To test memory I'm using perfmon, and am testing private bytes in Excel.
Any suggestions or a workaround?
Sample macro available illustrating this on request.
Claus