SortField Members (Excel)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.
Methods
Name |
Description |
|---|---|
Removes the specified SortField object from the SortFields collection. |
|
Modify the key value by which values are sorted in the field. |
|
Sets an icon for a SortField object. |
Properties
Name |
Description |
|---|---|
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. Read-only. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Specifies a custom order to sort the fields. Read/write Variant. |
|
Specifies how to sort text in the range specified in SortField object. Read/write XlSortDataOption. |
|
Specifies the range that is currently being sorted on. Read-only. |
|
Determines the sort order for the values specified in the key. Read/write. |
|
Returns the parent object for the specified object. Read-only. |
|
Specifies the priority for the sort field. Read/write. |
|
Returns or sets what attribute of the cell to sort on . Read/write XlSortOn. |
|
Retun the value on which the sort is performed for the specified SortField object. Read-only. |