Worksheet.FilterMode Property (Excel)
True if the worksheet is in the filter mode. Read-only Boolean.
Syntax
expression .FilterMode
expression A variable that represents a Worksheet object.
Example
In the following example, the code returns True if the worksheet is in the filter mode.
Dim Worksheet1 As Worksheet
Dim returnValue As Boolean
returnValue = Worksheet1.FilterMode