Filters Property
Returns the Filters collection for the specified AutoFilter. The Filters collection contains one Filter object for each column in the filtered range. Read-only.
expression.Filters
expression Required. An expression that returns an AutoFilter object.
Example
This example turns on the AutoFilter for the range A1:C20, sets filters for columns A and C, and then applies the filters.
Sub Apply_AutoFilter()
Dim afFilters
Dim afCol1
Dim afCol3
' Turn on AutoFilter.
Spreadsheet1.Worksheets("Sheet1").Range("A1:C20").AutoFilter
' Set a variable to the AutoFilter object.
Set afFilters = Spreadsheet1.Worksheets("sheet1").AutoFilter
Set afCol1 = afFilters.Filters(1)
Set afCol3 = afFilters.Filters(3)
' Add a criteria that excludes blue from column A.
afCol1.Criteria.Add "blue"
' Add a criteria that excludes green from column A.
afCol1.Criteria.Add "green"
' Add a criteria that excludes yellow from column c.
afCol3.Criteria.Add "yellow"
' Apply the criteria.
afFilters.Apply
End Sub