ListObject.ShowAutoFilter Property (Excel)
Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.
Syntax
expression .ShowAutoFilter
expression A variable that represents a ListObject object.
Remarks
ShowAutoFilter property defaults to True for a new ListObject object.
Example
The following example displays the setting of the ShowAutoFilter property the default list in Sheet 1 of the active workbook.
Dim wrksht As Worksheet
Dim oListCol As ListColumn
Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
Set oListCol = wrksht.ListObjects(1)
Debug.Print oListCol.ShowAutoFilter