View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default First blank row in a column

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.