![]() |
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