Filter and Filters Members

Use the Filters collection to get the state and settings of autofilters on a worksheet. Use the AutoFilter object’s Filters property to get a reference to this collection. The Filters collection, and Filter object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Application 2

Count 1

Creator 2

Criteria 1

Criteria 2

Item 1

On

Operator

Parent 2

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.