Undo after macro

[cbh35711]

I've got a macro linked to ctrl-Q that is just paste values. Excel forgets anything you do before a macro once you run it. So i can't undo if i use this macro. Is there anyway around this failing in excel? I can understand their reasoning behind it, but this is a really easy macro just one line.

Thanks for your help,

Chris

[dominicb]

Good afternoon 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

[cbh35711]

Thanks for the fast response dominicb.

Chris