| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Auto Filter - if on, turn off before running macro
I can't figure out how to do this. Before my macro runs I want to check to
see if AutoFilter is turned on. If it is I want to turn it off - if it isn't then do nothing. Rows("2:4").Select Selection.EntireRow.Hidden = False Range("A2").Select Selection.ClearContents Range("I2").Select 'Application.Run "'NamedInsuredList 2 11-2009.xls'!CheckBoxFilter_Click" Range("PolicyList").Sort Key1:=Range("A7"), Order1:=xlAscending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortTextAsNumbers Range("A2").Select |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn on Auto Filter?? It is grayed out. | Excel Discussion (Misc queries) | |||
| Turn off a filter before running a macro | Excel Programming | |||
| Macro to allow auto filter after running password protect | Excel Discussion (Misc queries) | |||
| Auto filter multiple selection turn off | Excel Discussion (Misc queries) | |||
| excel: how to turn auto-filter on? | Excel Worksheet Functions | |||
Threaded Mode
