how to run a macro x number of times where i can change x

[still learning]

Hi
I want to be able to run a macro x number of times where x is in a cell that i can change the number before i run it

mike

 

[GWteB]

The easiest way to do that is with two macros.

Sub ManyTimes()

    Dim i As Long

    For i = 1 To ThisWorkbook.Worksheets("Sheet1").Range("A1").Value

        MyMacro     'name of macro to run multiple times as of value in cell A1 on Sheet1

    Next i
End Sub

 

[still learning]

Hi GWteB

Thanks

mike