Exceluser111
New Member
- Joined
- Jan 14, 2015
- Messages
- 7
I have a data set and I am using the following for loop:
now for whatever reason, this for loop just doesn't even look at row 9, it goes from 8 to 10 and I cannot for the life of me figure out why.
Utilizing the debug print I can confirm that out of the 97 lines, only row 9 which happens to be the second row (row 8 to 104) gets completely skipped.
VBA Code:
For Each Row In lookupRange.Rows
Debug.Print Row.Cells(10).Address
If Row.Cells(10).Value < lookupValue Then
Row.Cut destWorksheet.Range("A" & lastRow)
lastRow = lastRow + 1
End If
Next Row
now for whatever reason, this for loop just doesn't even look at row 9, it goes from 8 to 10 and I cannot for the life of me figure out why.
Utilizing the debug print I can confirm that out of the 97 lines, only row 9 which happens to be the second row (row 8 to 104) gets completely skipped.