Hi,

Have a look at this article
http://www.jkp-ads.com/articles/UndoWithVBA00.asp

Cheers
Andy
ben wrote:
Hello.

I have a macro that I recorded which works great. It does a copy and
special paste to another work sheet. The only problem is that after it
has run, if I made some kind of mistake and it copied the wrong stuff
(or whatever), I cannot click on undo or alt-backspace. Is there anyway
that the copy and paste of the macro can be undone this way?

Thanks,
Ben

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info