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.ApplyEnd Sub

Applies to | AutoFilter Object

See Also | AutoFilter Method