Sort a specified range in the workbook.
Overload Name | Description |
---|---|
General | Sort All, Comments, Contents, or Formats from a specified range. |
Sort All, Comments, Contents, or Formats from a specified range.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell (8.0) | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder (8.0) | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition (8.0) |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SortRangeAddress | The address of a range to sort. |
SortBy |
Whether to sort by row or column.
Specify one of the following values or an arbitrary value:
<blank> Row Column
|
CaseSensitive |
Whether the sort is case sensitive.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SortInstructions_1 | The index (row or column number), and the supporting arguments (Order=Asc/Desc, TextAsNumbers=True/False), separated by commas. For example, if the sort is by row, then "1, Asc, False" would indicate that the sort is on the first column, Ascending order, and without TextAsNumbers. |
SortInstructions_2 | The index (row or column number) of the second sort, and the supporting arguments (Order=Asc/Desc, TextAsNumbers=True/False), separated by commas. For example, if the sort is by row, then "1, Asc, False" would indicate that the sort is on the first column, Ascending order, and without TextAsNumbers. |
SortInstructions_3 | The index (row or column number) of the third sort, and the supporting arguments (Order=Asc/Desc, TextAsNumbers=True/False), separated by commas. For example, if the sort is by row, then "1, Asc, False" would indicate that the sort is on the first column, Ascending order, and without TextAsNumbers. |
SortInstructions_4 | The index (row or column number) of the fourth sort, and the supporting arguments (Order=Asc/Desc, TextAsNumbers=True/False), separated by commas. For example, if the sort is by row, then "1, Asc, False" would indicate that the sort is on the first column, Ascending order, and without TextAsNumbers. |
SortInstructions_5 | The index (row or column number) of the fith sort, and the supporting arguments (Order=Asc/Desc, TextAsNumbers=True/False), separated by commas. For example, if the sort is by row, then "1, Asc, False" would indicate that the sort is on the first column, Ascending order, and without TextAsNumbers. |