ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting a range (https://www.excelbanter.com/excel-programming/380833-re-deleting-range.html)

PCLIVE

Deleting a range
 
One possible way:

Range("A11:A" & Range("A65536").End(xlUp).Row).Select
Selection.Delete Shift:=xlToLeft

HTH,
Paul

"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





All times are GMT +1. The time now is 01:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com