How to run a macro many times quicker?

  • Thread starter Thread starter cyberdude
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to run a macro many times simpler? 3
Macro error 1
Macro for data and time 2
Macro problems 3
Excel macro list - Alt+F8 2
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Excel 2007: Help creating a macro that will run Solver? 3
Running a macro based on the time 1

Back
Top