Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete row and 3 rows below by range selected
The below code does not work, but how can i get it carry out what it says?
Private Sub CommandButton13_Click() With activeworksheet Dim rng As Range Set rng = Range("A28,A32,A36,A40,A44,A48,A52,A56,A60") If ActiveCell = rng Then ' <=== If selected cell is in range above ?? ..Row -.Row + 4 '<==== Then delete the ROW that the selected cell is in and the 3 ROWS below it ALSO?? ..Delete End If End With End Sub Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete selected range | Excel Programming | |||
delete every nth row in selected range | Excel Discussion (Misc queries) | |||
Delete non-selected rows | Excel Programming | |||
Delete Selected Rows | Excel Programming | |||
Need a macro to delete selected rows | Excel Programming |