Worksheet.AutoFilterMode property (Excel)

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.