How to clean the memory for undo?

E

Eric

Does anyone have any suggestions on how to clean the memory for undo?
Thanks for any suggestions
Eric
 
M

Mike H

Eric,

One way:-

Sub cleanundo()
Range("A1").Copy Range("A1")
End Sub

you could put the same line of code in an event module such as worksheet
change to clear the undo stack automatically.

Mike
 
G

Gord Dibben

Run any non-destructive macro.

Sub clear()
ActiveCell.Copy Destination:=ActiveCell
End Sub


Gord Dibben MS Excel MVP
 
Top