Visit John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip23.htm
for one method.

"Chris W." wrote:

Hi,
Does anyone have a procedure or knows how to jury-rig a
function that can mimic the undo action, that will allow
you to return the worksheet back to its state prior to
programmaticly made changes. I cannot use a simple,
Close/don't-save-changes routine, because I want to keep
the form active and its values and all the underlying
variables unchanged. Any help will be greatly
apprecaited. Thanks all.

--

Dave Peterson