PDA

View Full Version : RowNext starting from a certain Row



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.

SamT
12-09-2013, 11:45 PM
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.

Say What?


RowNext = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row + 2
If RowNext < 5 Then RowNext = 5