Debug: For,next does not start at specified row

**xxgirlinbluexx** · 08-01-2013, 11:10 PM

I have the following code that when run starts at row 1 instead of 84. For the life of me I cannot figure out why this is so.

Please Login or Register  to view this content.

The odd things is, when I run my entire macro, it starts at row 84 and stops right there. It doesn't move on to the next row. So I'm stuck with only 1 miserly entry. My full code is as follows:

Please Login or Register  to view this content.

Anybody have any ideas?

**protonLeah** · 08-02-2013, 10:53 PM

Well, you didn't attach a workbook, so, ...
--------------------------------
Notice that the line j = Sheets("MasterList").Cells(Rows.Count, 4).End(xlUp).Row is inside your For i... loop; therefore, it will be re-initialized to the number of the last used row in Sheets("MasterList") column D each time your I-loop increments.

Say, Sheets("Sheet1 (3)"), is using 200 rows and Masterlist is using 1200 rows. Then your i loop will increment from 84 to 200, and each time, j will be initialized to 1200. Notice, also that j is never incremented! Thus the lines:

Sheets("MasterList").Cells(j + 1, 1).Value = Sheets("Sheet1 (3)").Cells(i, 3).Value
Sheets("MasterList").Cells(j + 1, 2).Value = Sheets("Sheet1 (3)").Cells(i, 4).Value
Sheets("MasterList").Cells(j + 1, 3).Value = Sheets("Sheet1 (3)").Cells(i, 5).Value

will write in Masterlist row 1201 for each increment of i. J never changes it always points at row 1201 ( in this case).