Filter Properties (Excel)

This object has the following properties:

Name

Description

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.

Count

Returns the number of objects in the collection. Read-only Long.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Criteria1

Returns the first filtered value for the specified column in a filtered range. Read-only Variant.

Criteria2

Returns the second filtered value for the specified column in a filtered range. Read-only Variant.

On

True if the specified filter is on. Read-only Boolean.

Operator

Returns an XlAutoFilterOperator value that represents the operator that associates the two criteria applied by the specified filter.

Parent

Returns the parent object for the specified object. Read-only.

Show:
© 2015 Microsoft