|Excel Developer Reference|
Returns the second filtered value for the specified column in a filtered range. Read-only Variant.
expression A variable that represents a Filter object.
If you try to access the Criteria2 property for a filter that does not use two criteria, an error will occur. Check that the Operator property of a Filter object doesn’t equal zero (0) before trying to access the Criteria2 property.
The following example sets a variable to the value of the Criteria2 property of the filter for the first column in the filtered range on the Crew worksheet.
|Visual Basic for Applications|