View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default SELECTING LAST ROW

Rows(80).Resize(Cells(Rows.Count,"A").End(xlUp).Ro w-79).Delete

--
__________________________________
HTH

Bob

"da" wrote in message
...
How do I select and delete row 80 to the last row which is 65,000?