How do I reset a for next loop in the script?

I am not really pasting the number 12 to each cell, in all actuallity I am pasting an entire spreadsheet of data from two other sources with calculations and references. Too much to add to this post. just trying to make it simple. As to the second fix, I tried that some time ago and the for next loop still does not reset for some reason (this is confusing since even the cobol and fortran I learned with allowed for reset on re-declaration of the for statement). Thanks though, BAT

help on for-next.xlsmIf it helps I have posted the entire spreadsheet with the vba. I am only concerned with the reasoning behind the failed reset of the multiple for-next loops (yes there are several).

In the Macros list is the file I wanted help with (Macro1) and the eventual fix I used for the problem (Button_3_click). I am not looking for a fix to the problem in my macros, but only an understanding of how to use multiple for-next loops such that they reset.

I see these as a clock-work where each 60 seconds the next array element (minutes) updates and the for-next "seconds" loop repeats. The only problem I have is how to tell the clock to reset the seconds hand for the next minute.

I know this is a simple problem and is covered in VBA 101, first week or so, but I am at a loss.

Please help me understand for future reference. Thanks, Brian Trease