AutoFilter Object Members

  • Article
Excel Developer Reference

Represents autofiltering for the specified worksheet.

Methods

  Name Description
Bb255835.methods(en-us,office.12).gif ApplyFilter Applies the specified Autofilter object.
Bb255835.methods(en-us,office.12).gif ShowAllData Displays all the data returned by the AutoFilter object.

Properties

  Name Description
Bb255835.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.
Bb255835.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb255835.properties(en-us,office.12).gif FilterMode Returns True if the worksheet is in the AutoFilter filter mode. Read-only Boolean.
Bb255835.properties(en-us,office.12).gif Filters Returns a Filters collection that represents all the filters in an autofiltered range. Read-only.
Bb255835.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255835.properties(en-us,office.12).gif Range Returns a Range object that represents the range to which the specified AutoFilter applies.
Bb255835.properties(en-us,office.12).gif Sort Gets the sort column or columns, and sort order for the AutoFilter collection.