Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting a range | Excel Programming | |||
Deleting Range name's listed in the range address box. | Excel Discussion (Misc queries) | |||
Deleting Range using VB | Excel Programming | |||
Programatically deleting Range | Excel Programming | |||
Deleting range not a row | Excel Programming |