Select first blank row

[tone640]

I'm having trouble with selecting the first blank row (I have trawled dozens of threads). So far I have this:

Rows(Range("A" & Rows.Count).End(xlUp).Row).Offset(1, 0).Select

This selects the first row where column A contains no data. My range goes from A:AO, but I do not know how to incorporate that in this line.

I tried:

Rows(Range("A:AO" & Rows.Count).End(xlUp).Row).Offset(1, 0).Select

and

Rows(Columns("A:AO" & Rows.Count).End(xlUp).Row).Offset(1, 0).Select

Thanks in advance.

[MaczaQ]

try this

Please Login or Register  to view this content.

or this:

Please Login or Register  to view this content.

Best Regards
MaczaQ

[snb]

to find the first empty cell in column A from 'the bottom'

Please Login or Register  to view this content.

to indicate that row:

Please Login or Register  to view this content.

[tigertiger]

I'm having trouble with selecting the first blank row
This selects the first row where column A contains no data. My range goes from A:AO, but I do not know how to incorporate that in this line.

try an alternative, only select from range A*:AO* ( A* the first cell contain no data)

Please Login or Register  to view this content.

For select entire row

Please Login or Register  to view this content.

[KRAND]

I use this code:

Please Login or Register  to view this content.

[tone640]

Most of the above have the same effect, or don't work. Please see attached.

[MaczaQ]

if you want to select first empty row where no value is set in range A:AO you can use just this:

Please Login or Register  to view this content.

Best Regards
MaczaQ

[tone640]

Thanks MaczaQ, spot on.

[tigertiger]

Or an other way

Please Login or Register  to view this content.