How to run a macro many times simpler?

[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

 

[Tom Ogilvy]

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

 

[Colo]

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

 

[JulieD]

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