Applies the specified AutoFilter. You typically use the AutoFilter method to turn on the AutoFilter and add one or more criteria to it; you can then use the Apply method to apply the new filter.
expression.Apply
expression 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.
Private Sub EnableAutoFilter()
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