FilterMode Property Example
This example displays the filter status of Sheet1 in a message box.
If Worksheets("Sheet1").FilterMode = True Then MsgBox "Filter mode is on" Else MsgBox "Filter mode is off" End If