FilterMode Property

True if the worksheet is in filter mode. Read-only Boolean.

Remarks

This property is True if the worksheet contains a filtered list in which there are hidden rows.

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