Problem with Loops

[chrgrose]

Sub runner()
Dim a As Long

For a = 1 To 12 Step 1
  "Do something"
  Loop
Next a

End Sub

How do this task 100 times without repeating the whole "For..." code? Right now I have a sheet like this and the only way I can keep it running is if I manually run it over and over. I've tried to nest this loop in another loop but it acts like it can't redo the loop if it's already been performed.

 

[Jonmo1]

It's hard to say without seeing the actual code you're trying to use, and not a simplified example.

Are you trying to do a loop within a loop?

Try something like

For a = 1 to 12
   'This line is executed only 12 times (each loop of a)
    For b = 1 to 100
       'This line is executed a total of 1200 times
       '100 loops of b X 12 loops of a
    Next b
Next a