SortField Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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: