Worksheet.AutoFilterMode Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .AutoFilterMode

expression A variable that represents a Worksheet object.

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.

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

If Worksheets("Sheet1").AutoFilterMode Then 
 isOn = "On" 
 isOn = "Off" 
End If 
MsgBox "AutoFilterMode is " & isOn