Find first empty row down to up

[nsnewbe]

first i go to the last row:
Cells(Rows.Count, 1).End(xlUp).Offset(1).Select

and from there i want to find (and select) the first empty row above
(so from down to up)

Hopes anyone can help
thx

 

[Gary McMaster]

The "CurrentRegion" property will probably work.

Cells(Rows.Count, 1).End(xlUp).Select
ActiveCell.CurrentRegion(1).Offset(-1).Select

Hope it works for you.

Gary

 

[nsnewbe]

works great
thankyou