Application.Undo Method (Excel)
Cancels the last user-interface action.
Syntax
expression .Undo
expression A variable that represents an Application object.
Remarks
This method undoes only the last action taken by the user before running the macro, and it must be the first line in the macro. It cannot be used to undo Visual Basic commands.
Example
This example cancels the last user-interface action. The example must be the first line in a macro.
Application.Undo