Select last empty row with header

[av8tordude]

I'm using the code below to move to the last empty row. However if the last empty row is below the header (Header is at row 6), it selects the header. How can I select the last empty row without adding +1 to the code or using an if statement?


Cells(Range("A" & Rows.Count).End(xlUp).Row, 1).Activate

[Fluff]

How about
Range("A"&Rows.Count).End(xlUp).Offset(1).activate

[SamT]

How can I select the last empty row without adding +1 to the code
You can't.

Technically, Fluff is "adding 1." Just doesn't look like it.

[Fluff]

@SamT
That's very true, but if where getting technical I think it should be

Range("A"&Rows.Count).activateFor the "Last" empty row. :)