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.

Richard

something like:

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

Regards

Trevor


"Richard" wrote in message
...
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.

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


"Richard" wrote in message
...
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.

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

Alan Beban

Richard wrote:
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.