Clear Undo?

's Computer Specifications

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

's Computer Specifications

Undo doesn't record changes made by VBA.

So I don't think you have a concern there.

--
Regards,
Tom Ogilvy

"Zone" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

's Computer Specifications

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
>
>

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >

's Computer Specifications

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
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[2008] Clear contents of textbox, reverting transaction with textbox method undo	Rob W	Microsoft VB .NET	0	6th Mar 2009 10:39 AM
Can I clear UNDO list?	Duke	Microsoft Excel Worksheet Functions	1	2nd Mar 2009 05:01 PM
VS 2008 update causes VS2005 to no longer clear undo history on document close	PJ6	Microsoft Dot NET	1	17th Jan 2009 04:57 AM
undo or clear information	Allan Murphy	Microsoft Access	2	30th Sep 2007 02:56 AM
Clear Undo stack to a particular step	=?Utf-8?B?U2F0?=	Microsoft Word Document Management	2	24th May 2005 12:37 AM