FilterMode Property

Applies To

Worksheet Object.

Description

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

Remarks

This property will be 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