Compartilhar via

Filters.Item Property

  • Artigo
Excel Developer Reference

Returns a single object from a collection.

Syntax

expression.Item(Index)

expression   A variable that represents a Filters object.

Parameters

Name Required/Optional Data Type Description
Index Required Long The index number of the object.

Example

The following example sets a variable to the value of the On property of the filter for the first column in the filtered range on the Crew worksheet.

Visual Basic for Applications 
  Set w = Worksheets("Crew")
If w.AutoFilterMode Then
    filterIsOn = w.AutoFilter.Filters.Item(1).On
End If

See Also