Worksheet.FilterMode Property

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

See Also

• Worksheet Object
• Worksheet Object Members