Application.Repeat Method

Excel Developer Reference

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.

Visual Basic for Applications
  Application.Repeat

See Also