Thread
:
Deleting a range
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Deleting a range
Don't know how that got there. Take out the ob
--
Don Guillett
SalesAid Software
"Gwen" wrote in message
...
Thank you, but what is job?
"Don Guillett" wrote:
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