Filters.Item Property (Excel)

Returns a single object from a collection.


expression. Item( _Index_ )

expression A variable that represents a Filters object.


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


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.

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

See also

Filters Object