VBA: Undo Last Action

[SteveOranjin]

Hello,

Hope you are all well. I love my Macro's, they're great. From time to time though, I run one of my macros and something happens that I didn't anticipate. Normally, when such a thing happens I can hit the key command Control + Z and then boom! I can undo the last action that I've done. I've noticed however, that when I run one of my macros this is not the case. My guess is, that when a macro runs, it clears the RAM and or some other type of memory where my last action was stored. Is there a way for me to write something into some of my macros so this does NOT happen? If so, can someone walk me through that?

Hope you are well,

Steve

 

[alansidman]

You would have to have written code that reverses the action. Once VBA is run, there is no reversibility action within Excel for VBA. I always make sure to have a saved copy that I can revert to before running any VBA.

 

[Joe4]

See here: http://spreadsheetpage.com/index.php/tip/undoing_a_vba_subroutine/