Good evening drgogo
Further to JBeaucaire's answer, there are a couple of pages on John Walkenbachs pages explaining the situation and how to go about seting up an "undo" routine :
http://spreadsheetpage.com/index.php..._undo_problem/
http://spreadsheetpage.com/index.php...ba_subroutine/
However Jan Karel Pieterse has come up with a generic undo routine which is available to download from here :
http://www.jkp-ads.com/Articles/UndoWithVBA00.asp
HTH
DominicB
Bookmarks