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