View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Last Row with Content - As a row

Cells(Rows.Count,"A").End(xlUp).Entirerow.Select

based on the contents of column A.
If you want to search on multiple columns, it's a bit more complicated.

HTH
--
AP

"nemadrias" a écrit dans le message de news:
...
How would I select (and I do mean actually select the row) the last row
that has data in it?

I need to be able to say:

LastRow.select in essence and then do whatever I need with that row.
Thanks!
Steve