Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
AutoFilterMode Property

Worksheet.AutoFilterMode Property

Office 2007
True if the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the FilterMode property. Read/write Boolean.

Syntax

expression.AutoFilterMode

expression   A variable that represents a Worksheet object.

Remarks

This property returns True if the drop-down arrows are currently displayed. You can set this property to False to remove the arrows, but you cannot set it to True. Use the AutoFilter method to filter a list and display the drop-down arrows.

Example

This example displays the current status of the AutoFilterMode property on Sheet1.

Visual Basic for Applications
If Worksheets("Sheet1").AutoFilterMode Then
    isOn = "On"
Else
    isOn = "Off"
End If
MsgBox "AutoFilterMode is " & isOn



Community Additions

ADD
Show:
© 2015 Microsoft