How to clean the memory for undo?
 

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

How to clean the memory for undo?
 

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

"Eric" wrote:

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

How to clean the memory for undo?
 

Run any non-destructive macro.

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


Gord Dibben MS Excel MVP

On Sat, 27 Oct 2007 21:45:01 -0700, Eric wrote:

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

How to clean the memory for undo?
 

Eric,

Saving the file clears the undo history.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------
"Eric" wrote in message
...
Does anyone have any suggestions on how to clean the memory for undo?
Thanks for any suggestions
Eric