Sort Object Members

  • Article
Excel Developer Reference

Represents a sort of a range of data.

Methods

  Name Description
Bb225698.methods(en-us,office.12).gif Apply Sorts the range based on the currently applied sort states.
Bb225698.methods(en-us,office.12).gif SetRange Sets the starting and ending character positions for Sort object.

Properties

  Name Description
Bb225698.properties(en-us,office.12).gif 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.
Bb225698.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb225698.properties(en-us,office.12).gif Header Specifies whether the first row contains header information. Read/write XlYesNoGuess.
Bb225698.properties(en-us,office.12).gif MatchCase Set to True to perform a case-sensitive sort or set to False to perform non-case sensitive sort. Read/write.
Bb225698.properties(en-us,office.12).gif Orientation Specifies the orientation for the sort. Read/write XlSortOrientation.
Bb225698.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225698.properties(en-us,office.12).gif Rng Return the range of values on which the sort is performed. Read-only.
Bb225698.properties(en-us,office.12).gif SortFields Stores the sort state for workbooks, lists, and autofilters. Read-only.
Bb225698.properties(en-us,office.12).gif SortMethod Specifies the sort method for Chinese languages. Read/write XlSortMethod.