| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter and unfilter
I have a very simple macro that saves the user from having to go to the
custom autofilter: Selection.AutoFilter Field:=8, Criteria1:="<Holiday", Operator:=xlAnd I want to switch this to a toggle - so that if field 8 is already filtered, then it will run the command Selection.AutoFilter Field:=8 What is the IF statement to use to determine if field 8 is already filtered? Thanks in advance Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unfilter | Excel Discussion (Misc queries) | |||
| Code to unfilter if filtered | Excel Programming | |||
| excel should let me unfilter all columns with one click | Excel Programming | |||
| Code to unfilter one field only | Excel Programming | |||
| Unfilter | Excel Programming | |||
Threaded Mode
