AutoFilterMode Property

Applies To

Worksheet Object.

Description

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

Remarks

This property will be 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.

See Also

AutoFilter Method, FilterMode Property.

Example

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

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