Filter Object Members

  • Article
Excel Developer Reference

Represents a filter for a single column.

Properties

  Name Description
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.