Apply Method

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   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