FilterMode Property
Applies To
Worksheet object.
Description
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.
See Also
AdvancedFilter method, AutoFilter method, AutoFilterMode property, ShowAllData method.
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