Forum Discussion
Undo Macro actions
Hi There I've created a macro that copy some lines and delete values manually entered. I then entered a row above the lines being copied and now the macro has deleted al my formulas - which took ...
Sorry, but if you didn't create a backup, your work is gone. When VBA code makes a change on the grid, it clears the undo stack. Unfortunately, Excel doesn't have a special UndoRecord method like Word does. I don't know why, it'd be pretty awesome.
First rule of spreadsheeting: always keep a backup.
Second rule of spreadsheeting: always keep a backup of your backup.
Third rule of spreadsheeting: backup your backups.
Fourth rule of spreadsheeting: save often, backup more often.
First rule of spreadsheeting: always keep a backup.
Second rule of spreadsheeting: always keep a backup of your backup.
Third rule of spreadsheeting: backup your backups.
Fourth rule of spreadsheeting: save often, backup more often.