SortField SortField SortField Interface


The SortField object contains all the sort information for the Worksheet, ListObject, and AutoFilter objects.

public interface class SortField
public interface SortField
Public Interface SortField


Application Application 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 Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only.

CustomOrder CustomOrder CustomOrder

Specifies a custom order to sort the fields. Read/write.

DataOption DataOption DataOption

Specifies how to sort text in the range specified in SortField object. Read/write.

Key Key Key

Specifies the range that is currently being sorted on. Read-only.

Order Order Order

Determines the sort order for the values specified in the key. Read/write.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

Priority Priority Priority

Specifies the priority for the sort field. Read/write.

SortOn SortOn SortOn

Returns or sets what attribute of the cell to sort on . Read/write.

SortOnValue SortOnValue SortOnValue

Retun the value on which the sort is performed for the specified SortField object. Read-only.


Delete() Delete() Delete()

Removes the specified SortField object from the SortFields collection.

ModifyKey(Range) ModifyKey(Range) ModifyKey(Range)

Modify the key value by which values are sorted in the field.

SetIcon(Icon) SetIcon(Icon) SetIcon(Icon)

Sets an icon for a SortField object.

Applies to