Worksheet.FilterMode Property (Excel)

True if the worksheet is in the filter mode. Read-only Boolean.

expression .FilterMode

expression A variable that represents a Worksheet object.

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
Show:
© 2014 Microsoft