| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clean Function | Excel Discussion (Misc queries) | |||
| Not enoguh memory. Continue with Undo? | Excel Discussion (Misc queries) | |||
| UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
| Get out clean XML data | Excel Discussion (Misc queries) | |||
| Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
Linear Mode
