AutoFilterMode Property Example

This example displays the current status of the AutoFilterMode property on Sheet1.

If Worksheets("Sheet1").AutoFilterMode Then
    isOn = "On"
Else
    isOn = "Off"
End If
MsgBox "AutoFilterMode is " & isOn