Run a macro x time in a row

[daniroy]

Hello there,

another dumb question. I want to run the macro x times in a row, lets
say 10 times for instance, what code should I add ?

Thanks a lot for your help
Daniel

 

[Norman Jones]

Hi Daniroy,

Try something like:

Public Sub Tester()

Dim i as Long

For i = 1 to 10
Call MyMacro
Next i

End Sub

 

[daniroy]

work very fine thank you Norman for your help, it is appreciated
....