Worksheet.FilterMode Property

  • Article
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