Undo after macro

Good afternoon cbh35711

Originally Posted by cbh35711

Is there anyway around this failing in excel?

Nope. Fraid not. This is a massive failing in Excel and a huge grumble amongst users that almost any macro, even the tidgiest, tiniest one will clear your entire undo stack.

Microsoft have kindly left a small provision in there for you to undo the effect of your macro (see link below) but your undo stack can't be recovered.

http://www.j-walk.com/ss/excel/tips/tip23.htm

HTH

DominicB