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

if you can provide a sample file with some sample data or at least how you expect to see the results, that would help other assist.

Here you go!

Thanks!

We still need to understand where you want to see your results and what you mean by a different cell

Are you saying that you want the second outputs of 50 results starting in BM 23, then the next in BN..etc.

In which case jus wrap your loop in another loop 1 to 50 loop and use that loop index to move across columns.e.g.

Please Login or Register  to view this content.

In that case just add an instruction to update the results table

Please Login or Register  to view this content.