Repeat Method

Microsoft Excel Visual Basic

Repeats the last user-interface action.

expression.Repeat

expression    Required. An expression that returns 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