ListObject.ShowAutoFilter Property

Excel Developer Reference

Returns Boolean to indicate whether the AutoFilter will be displayed. Read/write Boolean.



expression   A variable that represents a ListObject object.


ShowAutoFilter property defaults to True for a new ListObject object.


The following example displays the setting of the ShowAutoFilter property the default list in Sheet 1 of the active workbook.

Visual Basic for Applications
   Dim wrksht As Worksheet
   Dim oListCol As ListColumn
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set oListCol = wrksht.ListObjects(1)

Debug.Print oListCol.ShowAutoFilter

See Also