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

Sub currentMacroName()
for i = 1 to 10
' current code
Next
End Sub

--
Regards,
Tom Ogilvy

"cyberdude" wrote in message
om...
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

Mic

or you can CALL that procedure from another procedure using a loop.


Code
-------------------

Sub RunMacroManyTines()
Dim i As Long
For i = 1 To 100
Call YourMacro 'plece here the name of your procedure
Next
End Sub

Sub YourMacro()
Debug.Print "hey"
End Sub

-------------------


--
Message posted from http://www.ExcelForum.com

following on from Tom's suggestion you can make the number of times
interactive e.g.

Sub currentMacroName()
for i = 1 to inputbox("How many times would you like to run the code?","Run
Code",10)
' current code
Next
End Sub

"cyberdude" wrote in message
om...
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