SortField Members
Include Protected Members
Include Inherited Members
The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.
The SortField type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object. Read-only. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. Read-only. |
|
CustomOrder | Specifies a custom order to sort the fields. Read/write. |
|
DataOption | Specifies how to sort text in the range specified in SortField object. Read/write. |
|
Key | Specifies the range that is currently being sorted on. Read-only. |
|
Order | Determines the sort order for the values specified in the key. Read/write. |
|
Parent | Returns the parent object for the specified object. Read-only. |
|
Priority | Specifies the priority for the sort field. Read/write. |
|
SortOn | Returns or sets what attribute of the cell to sort on . Read/write. |
|
SortOnValue | Retun the value on which the sort is performed for the specified SortField object. Read-only. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Delete | Removes the specified SortField object from the SortFields collection. |
|
ModifyKey | Modify the key value by which values are sorted in the field. |
|
SetIcon | Sets an icon for a SortField object. |
Top