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

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