Export (0) Print
Expand All

Worksheet.FilterMode Property

Office 2007
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



Community Additions

ADD
Show:
© 2014 Microsoft