Share via

Filters Property

  • Article

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

Applies to | AutoFilter Object

See Also | Filter Property