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
Leave a comment | Trackback
No comments yet.