UNDO in EXCEL97 macro

[david]

I have an EXCEL97 macro that is doing lots of changes to a
worksheet. The Macro eventually fails with "Not enough
memory" and I think it may be storing UNDO info as it
goes. Is there a way to turn UNDO off programatically in
the macro ?

 

[Peter Beach]

Hi David,

It's not going to be an undo buffer :-(

Sadly "Not enough memory" is a catch-all error - it's displayed when an
"unanticipated" error is encountered.

These are nasty errors to track down. The normal approach is to start
taking out lines of code until it starts working, and in that way isolate
what's going wrong. Obviously you don't literally remove them, commenting
lines out is the normal way.

HTH

Peter Beach

 

[Patrick Molloy]

I suspect that your code may not be releasing memory
correctly. the "undo" buffer is not used by the app when
code is run.

Without seeing the code, it snot possibl;e to comment
further.

Patrick Molloy
Microsoft Excel MVP