Application.Repeat Method (Excel)
Repeats the last user-interface action.
Syntax
expression .Repeat
expression A variable that represents an Application object.
Remarks
This method repeats 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 repeat Visual Basic commands.
Example
This example repeats the last user-interface command. The example must be the first line in a macro.
Application.Repeat