SOLVED Help to VBA loop

Hey guys!

I have the following VBA code:

Sub TEST()
For Iteration = 1 To Cells(15, 16)
Cells(10 + Iteration, 13) = Cells(4, 18)
Cells(10 + Iteration, 12) = Iteration
Next Iteration

End Sub


I want to repeat this sub code 1000 times and store the value in a different cell. How do I code this loop?

Looking forward to your replies!

/Monfrizo