Hi everyone.

I'm trying to run a basic simulation supported by the below macro. The purpose of the macro is to effectively copy and paste 45 values generated in row 18 (which are tied to rand() formula cells and thus change with each update) and paste them into a table starting from row 23 and with a table-depth as defined in cell B3. The intention is that once the 45 values in row 18 have been copied into row 23, the values in row 18 update and these new values are then then pasted into row 24 and so forth until the number of rows in cell B3 has been reached. I also have a helper cell that counts the number of rows generated, so I when I run the macro I can see how much progress has been made before putting the kettle on.

My question is: when I run the macro I can see the values being generated in row 18 updating multiple times per second, but the number of rows being counted (by the helper cell) in my table progresses at a much slower rate. It looks as though multiple "iterations" are occurring per row update, but (accepting my very basic experience with VBA) I can't see why that would be. Is there anything I'm doing wrong?

Thanks for any help 

Sub Test1()
    For Iteration = 1 To Cells(3, 2)
    
        Cells(22 + Iteration, 5) = Cells(18, 5)
        Cells(22 + Iteration, 6) = Cells(18, 6)
        Cells(22 + Iteration, 7) = Cells(18, 7)
        Cells(22 + Iteration, 8) = Cells(18, 8)
        Cells(22 + Iteration, 9) = Cells(18, 9)
        Cells(22 + Iteration, 10) = Cells(18, 10)
        Cells(22 + Iteration, 11) = Cells(18, 11)
        Cells(22 + Iteration, 12) = Cells(18, 12)
        Cells(22 + Iteration, 13) = Cells(18, 13)
        
        Cells(22 + Iteration, 15) = Cells(18, 15)
        Cells(22 + Iteration, 16) = Cells(18, 16)
        Cells(22 + Iteration, 17) = Cells(18, 17)
        Cells(22 + Iteration, 18) = Cells(18, 18)
        Cells(22 + Iteration, 19) = Cells(18, 19)
        Cells(22 + Iteration, 20) = Cells(18, 20)
        Cells(22 + Iteration, 21) = Cells(18, 21)
        Cells(22 + Iteration, 22) = Cells(18, 22)
        Cells(22 + Iteration, 23) = Cells(18, 23)
        
        Cells(22 + Iteration, 25) = Cells(18, 25)
        Cells(22 + Iteration, 26) = Cells(18, 26)
        Cells(22 + Iteration, 27) = Cells(18, 27)
        Cells(22 + Iteration, 28) = Cells(18, 28)
        Cells(22 + Iteration, 29) = Cells(18, 29)
        Cells(22 + Iteration, 30) = Cells(18, 30)
        Cells(22 + Iteration, 31) = Cells(18, 31)
        Cells(22 + Iteration, 32) = Cells(18, 32)
        Cells(22 + Iteration, 33) = Cells(18, 33)
        
        Cells(22 + Iteration, 35) = Cells(18, 35)
        Cells(22 + Iteration, 36) = Cells(18, 36)
        Cells(22 + Iteration, 37) = Cells(18, 37)
        Cells(22 + Iteration, 38) = Cells(18, 38)
        Cells(22 + Iteration, 39) = Cells(18, 39)
        Cells(22 + Iteration, 40) = Cells(18, 40)
        Cells(22 + Iteration, 41) = Cells(18, 41)
        Cells(22 + Iteration, 42) = Cells(18, 42)
        Cells(22 + Iteration, 43) = Cells(18, 43)
        
        Cells(22 + Iteration, 45) = Cells(18, 45)
        Cells(22 + Iteration, 46) = Cells(18, 46)
        Cells(22 + Iteration, 47) = Cells(18, 47)
        Cells(22 + Iteration, 48) = Cells(18, 48)
        Cells(22 + Iteration, 49) = Cells(18, 49)
        Cells(22 + Iteration, 50) = Cells(18, 50)
        Cells(22 + Iteration, 51) = Cells(18, 51)
        Cells(22 + Iteration, 52) = Cells(18, 52)
        Cells(22 + Iteration, 53) = Cells(18, 53)
        
        Cells(22 + Iteration, 3) = Iteration
        
    Next Iteration
End Sub