Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFilter
Hi Gareth
Dim rng As Range On Error Resume Next Set rng = ActiveSheet.AutoFilter.Range On Error GoTo 0 If Not rng Is Nothing Then rng.AutoFilter End If -- HTH RP (remove nothere from the email address if mailing direct) "Gareth" wrote in message ... How, by code, can I check if autofilter is on? If it is on, switch it off. Thanks in advance. Gareth |
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) |