Share via


Worksheet.FilterMode Property

Excel Developer Reference

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.

Visual Basic for Applications
  Dim Worksheet1 As Worksheet

Dim returnValue As Boolean returnValue = Worksheet1.FilterMode

See Also