VBA: Turn Off Autofilter From Code

August 14th, 2004 | Categories: VBA | Tags:

-->

The following code example turns Off autofilter, checking first that it’s not Off already.

Public Sub KillFilter()

If ActiveSheet.AutoFilterMode Then
     ActiveSheet.AutoFilterMode = False
End If

End Sub

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!