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