View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dunnerca dunnerca is offline
external usenet poster
 
Posts: 22
Default 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.