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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.