Sort Method
Sorts a range or, if the specified range contains only one cell, the current region
expression.Sort(ColumnKey, Order, Header)
expression An expression that returns a Range object.
ColumnKey Optional Long. The number of the first sort column. The default value is 1.
Order Optional XlSortOrder. The sort order.
XlSortOrder can be one of these XlSortOrder constants. |
xlAscending default |
xlDescending |
Header Optional XlYesNoGuess. Determines whether the first row contains headers.
XlYesNoGuess can be one of these XlYesNoGuess constants. |
xlGuess Have the method determine whether the first row contains headers. |
xlNo default The first row does not contain headers. |
xlYes The first row contains headers. |
Example
This example sorts the range A1:F10 in descending order based on column B.
Sub SortData()
Dim ssConstants
Set ssConstants = Spreadsheet1.Constants
' Sort Range A1:F10 on column B in descending order and specify that
' row 1 contains headings.
Spreadsheet1.ActiveSheetRange("A1:F10").Sort 2, _
ssConstants.xlDescending, ssConstants.xlYes
End Sub