Worksheet.AutoFilterMode (Excel)

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

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.

ActiveSheet.AutoFilterMode = True