Excel Undo & Redo

 

The default Excel behavior is that any macro or code which writes directly to an Excel sheet resets the Excel's Undo stack.

 

Therefore, if you require Excel Undo:

1.For non-live functions, set the Autoformat (the last parameter of all functions) to FALSE

2.Do not use live functions and if you do, disable in the Options the Live Flashing Updates

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017