Keep track of what was there before and write your own routine to undo.

John Walkenbach has some notes:
http://www.j-walk.com/ss/excel/tips/tip23.htm

Kalin Vassilev wrote:

Haw can I apply ability of Undo function after executing Macros. Is there any
appropriate property of any object we can use to add in programme code of
Macros or what ever. Thanks in advance!

--

Dave Peterson