Share via

Apply Method

  • Article

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