Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Undo?
I'm clearing a bunch of drawing objects from my worksheet and
recreating them with VBA. Is Undo holding how all these old objects? If so, I'd like to clear it and free up that memory. Excel XP (2002) TIA, James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Undo?
Undo doesn't record changes made by VBA.
So I don't think you have a concern there. -- Regards, Tom Ogilvy "Zone" wrote in message ps.com... I'm clearing a bunch of drawing objects from my worksheet and recreating them with VBA. Is Undo holding how all these old objects? If so, I'd like to clear it and free up that memory. Excel XP (2002) TIA, James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Undo?
Based on what I have read about it, it is an ApplicationCommand Class command
which simply acts on the last transaction if the user invokes it. My understanding is that it is the amount of transactions that you generate before saving or closing that occupies the memory. However, I ain't all that smart. "Zone" wrote: I'm clearing a bunch of drawing objects from my worksheet and recreating them with VBA. Is Undo holding how all these old objects? If so, I'd like to clear it and free up that memory. Excel XP (2002) TIA, James |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Undo?
Many thanks, Tom. I can check this off my list. James
Tom Ogilvy wrote: Undo doesn't record changes made by VBA. So I don't think you have a concern there. -- Regards, Tom Ogilvy "Zone" wrote in message ps.com... I'm clearing a bunch of drawing objects from my worksheet and recreating them with VBA. Is Undo holding how all these old objects? If so, I'd like to clear it and free up that memory. Excel XP (2002) TIA, James |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Undo?
JLG, thanks for your reply. James
JLGWhiz wrote: Based on what I have read about it, it is an ApplicationCommand Class command which simply acts on the last transaction if the user invokes it. My understanding is that it is the amount of transactions that you generate before saving or closing that occupies the memory. However, I ain't all that smart. "Zone" wrote: I'm clearing a bunch of drawing objects from my worksheet and recreating them with VBA. Is Undo holding how all these old objects? If so, I'd like to clear it and free up that memory. Excel XP (2002) TIA, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer a name from one cell to another but leave clear if clear? | Excel Worksheet Functions | |||
Can I clear UNDO list? | Excel Worksheet Functions | |||
clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions |