| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows with different criteria
I have a simple macro that filters (hides) the data that is unapplicable in
each worksheet. How would I make the macro delete the rows that it is hiding in the autofilter? My code is below. THANKS! Selection.AutoFilter Field:=8, Criteria1:="<", Operator:=xlAnd Selection.AutoFilter Field:=14, Criteria1:="0", Operator:=xlAnd Selection.AutoFilter Field:=18, Criteria1:="=7.00", Operator:=xlAnd Sheets("AG Non Call").Select Selection.AutoFilter Field:=8, Criteria1:="=#N/A N Ap", Operator:=xlAnd Selection.AutoFilter Field:=14, Criteria1:="0", Operator:=xlAnd Selection.AutoFilter Field:=18, Criteria1:="=7.00", Operator:=xlAnd Sheets("CORPS").Select Selection.AutoFilter Field:=14, Criteria1:="0", Operator:=xlAnd Selection.AutoFilter Field:=18, Criteria1:="=8.00" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all rows if criteria not matched | Excel Discussion (Misc queries) | |||
| Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
| Delete rows where cells contain various criteria | Excel Programming | |||
| delete rows with criteria | Excel Programming | |||
| Delete rows w/o criteria | Excel Programming | |||
Threaded Mode
