Thread: Deleting rows to a defined point
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Martin Martin is offline
external usenet poster
  
Posts: 336
Default Deleting rows to a defined point
Range(Range("A7"), Range("lastline")).EntireRow.Delete


"Tim Green" wrote:

I would like to delete all rows from row 7 to the row number of the range
LastLine, which refers to a single cell. Any suggestions?
Reply With QuoteReply With Quote