Criteria Property

Microsoft Office Web Components Object Model

Criteria Property

       

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