This documentation is archived and is not being maintained.

Filter Object Members

Office 2007

Represents a filter for a single column.

Properties

 NameDescription
Bb242252.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb242252.properties(en-us,office.12).gif Count Read-only
Bb242252.properties(en-us,office.12).gif Criteria1 Returns the first filtered value for the specified column in a filtered range. Read-only Variant.
Bb242252.properties(en-us,office.12).gif Criteria2 Returns the second filtered value for the specified column in a filtered range. Read-only Variant.
Bb242252.properties(en-us,office.12).gif On True if the specified filter is on. Read-only Boolean.
Bb242252.properties(en-us,office.12).gif Operator Returns an XlAutoFilterOperator value that represents the operator that associates the two criteria applied by the specified filter.
Bb242252.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.


Show: