Emoncada
12-09-2013, 12:53 PM
I have this code.
RowNext = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 2
It works good, but Since it puts data every 2 rows, i need to tell it to start looking at row 5 down.
So if data is in Row 4, to put the data in Row 5 not Row 6, then jump to Row 7 and so on.
I am pretty sure it's something easy.
RowNext = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 2
It works good, but Since it puts data every 2 rows, i need to tell it to start looking at row 5 down.
So if data is in Row 4, to put the data in Row 5 not Row 6, then jump to Row 7 and so on.
I am pretty sure it's something easy.