Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
Get rid of the arrows????
ActiveSheet.AutoFilterMode = False It won't hurt if the sheet doesn't have autofilter applied. Keep the arrows, but show all the data??? With ActiveSheet If .AutoFilterMode Then If .FilterMode Then ..ShowAllData End If End If End With Gareth wrote: How, by code, can I check if autofilter is on? If it is on, switch it off. Thanks in advance. Gareth -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |