Excel.ListObject.ShowAutoFilter.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
ListObject.ShowAutoFilter property (Excel)	vbaxl10.chm734091	vbaxl10.chm734091	Excel.ListObject.ShowAutoFilter	ae9dfc8d-dd58-802d-2e96-461abdb9ee2b	04/30/2019	medium

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

The ShowAutoFilter property defaults to True for a new ListObject object.

Example

The following example displays the setting of the ShowAutoFilter property of the default list on Sheet1 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

[!includeSupport and feedback]