Filters.Item Property

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`

Returns a single object from a collection.