SortField Members (Excel)

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

Name

Description

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.

Name

Description

Application

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.

Creator

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

CustomOrder

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

DataOption

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

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 XlSortOn.

SortOnValue

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

Show:
© 2014 Microsoft