ListObject.ShowAutoFilter Property

  • Article
Excel Developer Reference

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.

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