SortField Object Members

  • Article
Excel Developer Reference

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

Methods

  Name Description
Bb225699.methods(en-us,office.12).gif Delete Removes the specified SortField object from the SortFields collection.
Bb225699.methods(en-us,office.12).gif ModifyKey Modify the key value by which values are sorted in the field.
Bb225699.methods(en-us,office.12).gif SetIcon Sets an icon for a SortField object.

Properties

  Name Description
Bb225699.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.
Bb225699.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.
Bb225699.properties(en-us,office.12).gif CustomOrder Specifies a custom order to sort the fields. Read/write Variant.
Bb225699.properties(en-us,office.12).gif DataOption Specifies how to sort text in the range specified in SortField object. Read/write XlSortDataOption.
Bb225699.properties(en-us,office.12).gif Key Specifies the range that is currently being sorted on. Read-only.
Bb225699.properties(en-us,office.12).gif Order Determines the sort order for the values specified in the key. Read/write.
Bb225699.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225699.properties(en-us,office.12).gif Priority Specifies the priority for the sort field. Read/write.
Bb225699.properties(en-us,office.12).gif SortOn Returns or sets what attribute of the cell to sort on . Read/write XlSortOn.
Bb225699.properties(en-us,office.12).gif SortOnValue Retun the value on which the sort is performed for the specified SortField object. Read-only.