Last Empty Row in Range
 

I have checked and seen many examples of how to find the last row in a column
by using

lastcell=.cells(.rows.count,1).end(xlUp)(2).select

However, that appears to look at the ENTIRE column. My data starts, say, in
row 15. How do I use the above code to look only at rows below row 15?

Thanks.

Last Empty Row in Range
 

See this page (Last function)
http://www.rondebruin.nl/last.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dunnerca" wrote in message ...
I have checked and seen many examples of how to find the last row in a column
by using

lastcell=.cells(.rows.count,1).end(xlUp)(2).select

However, that appears to look at the ENTIRE column. My data starts, say, in
row 15. How do I use the above code to look only at rows below row 15?

Thanks.

Last Empty Row in Range
 

Thanks, Ron. Exactly what I needed.

Kevin

"Ron de Bruin" wrote:

See this page (Last function)
http://www.rondebruin.nl/last.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dunnerca" wrote in message ...
I have checked and seen many examples of how to find the last row in a column
by using

lastcell=.cells(.rows.count,1).end(xlUp)(2).select

However, that appears to look at the ENTIRE column. My data starts, say, in
row 15. How do I use the above code to look only at rows below row 15?

Thanks.