Thread
:
Deleting a range
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett