SortField Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.
public interface class SortField[System.Runtime.InteropServices.Guid("000244A9-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface SortFieldPublic Interface SortField- Attributes
Properties
| Name | Description |
|---|---|
| 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. |
Methods
| Name | Description |
|---|---|
| Delete() |
Removes the specified SortField object from the SortFields collection. |
| ModifyKey(Range) |
Modify the key value by which values are sorted in the field. |
| SetIcon(Icon) |
Sets an icon for a SortField object. |