How to run a macro many times quicker?

C

cyberdude

Hi,

I have written a macro in Excel to run a series of key strokes with a
fast key, say Alt-a, to initiate the execution. But I need to run
that macro many times. One way to do that is pressing Alt-a the
needed number of times. May I ask if there is another way that does
it simpler? Thanks in advance.

Mic
 
B

Bob Umlas

Do you know how many times?
If your current macro is named "Mic", then you can insert these lines after
the Sub & End Sub lines:
Sub Mic()
For i=1 to 25 '25 is # of times to run it
.....'rest of your macro
Next
End Sub

Bob Umlas
Excel MVP
 
Top