AutoFilter Members
Include Protected Members
Include Inherited Members
Represents autofiltering for the specified worksheet.
The AutoFilter type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | 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. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator. |
|
FilterMode | Returns True if the worksheet is in the AutoFilter filter mode. Read-only Boolean. |
|
Filters | Returns a Filters collection that represents all the filters in an autofiltered range. Read-only. |
|
Parent | Returns the parent object for the specified object. Read-only. |
|
Range | Returns a Range object that represents the range to which the specified AutoFilter applies. |
|
Sort | Gets the sort column or columns, and sort order for the AutoFilter collection. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
ApplyFilter | Applies the specified AutoFilterobject. |
|
ShowAllData | Displays all the data returned by the AutoFilterobject. |
Top