Share via

Criteria Property

  • Article

Returns the Criteria object for the specified filter. Use the Add method of the Criteria object returned by this property to add criteria to a Filter object. Read-only.

expression.Criteria

expression   Required. An expression that returns a Filter 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