ListObject.ShowAutoFilter Property

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

See also:

• ListObject Object
• ListObject Object Members