Repeating Actions

If you want to repeat an action a single time, you can either press the F4 key or Ctrl+Y. What if you want to repeat it more than once, however? Granted, you could press these keys multiple times, but this can get tedious if you want to repeat something fifty or sixty times.

The answer is to use a nifty little macro that will do the repeating for you. The follow macro will do the trick:

Sub DoRepeat()
    Dim CountValue As Integer
    CountValue = Val(InputBox("How many times?"))
    If CountValue > 0 Then Repeat (CountValue)
End Sub

The trick is to assign DoRepeat to a keyboard shortcut, such as Alt+R. Then, you can perform an action, press Alt+R, enter the number of times to repeat, and be on your way. You should note that if the action you did prior to invoking the macro cannot be repeated for some reason, you will get an error when the macro tries to run.