Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Determine whether a ListObject object AutoFilter is turned on or off by testing its ShowAutoFilter property

Sub showFilter()      ActiveSheet.ListObjects("Table1").ShowAutoFilter = False End Sub