VBA: Turn On Autofilter From Code

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

-->

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

Public Sub StartFilter()

If Not ActiveSheet.AutoFilterMode Then
     ActiveSheet.Range("A1").AutoFilter
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!