First blank row in a column

[Richard]

A couple of weeks ago, someone in this group gave me a
very clean one-line macro to find the first blank row in a
column.

It had (xlDown) and Offset(0,1) in it but I can't remember
the whole thing.

Could someone please help me find it again?

Thanks in advance.

 

[Trevor Shuttleworth]

Richard

something like:

Range("A1").End(xlDown).Offset(1,0).Select

Regards

Trevor

 

[Chip Pearson]

Richard,

Assuming that there are at least two items at the top of the column, use

Range("A1").End(xlDown).Offset(1, 0).Select

Change A1 to the appropriate starting cell.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Alan Beban]

Nothing's easy. What do you mean "find" it? Return it's value? Return
it's address? Select it? Something else?

Alan Beban