VBA cannot use Undo/Redo button

[inetquestion]

I have a VBA function that does a copy/paste. After its been invoked there is no option to undo those changes other than closing the doc and reopening it. Is there any way around this sort of thing so that you can actually use undo/redo on the toolbar?

TIA,

-Inet

 

[jcrater]

Try Application.Undo

 

[TonyJollans]

Hi inetquestion,

What application? You mention a document - are you using Word? If so, the normal application Undo facility should be available for each action taken in the macro. If, on the other hand, you are using Excel, the built in Undo will not work on actions done via code and you will need to code your own logic which is probably more trouble than it's worth.

Is there something particular you are trying to achieve? Or is it just a general question?

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.