Sort Properties (Excel)

Office 2013 and later
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.

Header

Specifies whether the first row contains header information. Read/write XlYesNoGuess.

MatchCase

Set to True to perform a case-sensitive sort or set to False to perform non-case sensitive sort. Read/write.

Orientation

Specifies the orientation for the sort. Read/write XlSortOrientation.

Parent

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

Rng

Return the range of values on which the sort is performed. Read-only.

SortFields

Returns the SortFields object that represents the collection of sort fields associated with the Sort object. Read-only.

SortMethod

Specifies the sort method for Chinese languages. Read/write XlSortMethod.

Name

Description

Show:
© 2016 Microsoft