View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Deleting a range

to delete rows

lr=cells(rows.count,"a").end(xlup).row
range("a11:job" & lr).delete

--
Don Guillett
SalesAid Software

"Gwen" wrote in message
...
Please assist.
I want to programmatically delete a range.
The last row is never the same.
Range ("a11":"jlastrow")
I want to delete range("a13":"elastrow")
The remaining columns to shift to the left starting in cell "a11".

Thanks