Click or drag to resize

ExcelRangeSort Method

Overload List
 NameDescription
Public methodSort(ExcelSortKey, Boolean) Sorts the rows of this range by one or more columns: the rows with equal values in the first key column are sorted by the second key column and so on; rows with equal keys keep their order. The values, formulas and cell formats move with the rows; the relative references of the moved formulas are adjusted to the new row, as in Excel. Numbers and dates come before texts, texts are compared without regard to case and the blank cells are placed last. Formula cells are sorted by their calculated results (call UpdateFormulaResult first for the formulas added in code). The range cannot contain merged cells.
Public methodSort(ExcelSortKey, Boolean, Boolean) Sorts the rows of this range by one or more columns, optionally matching the case of the texts. The values, formulas and cell formats move with the rows; the relative references of the moved formulas are adjusted to the new row, as in Excel. Numbers and dates come before texts and the blank cells are placed last. Formula cells are sorted by their calculated results (call UpdateFormulaResult first for the formulas added in code). The range cannot contain merged cells.
Public methodSort(Int32, ExcelSortOrder, Boolean) Sorts the rows of this range by a column. The values, formulas and cell formats move with the rows; the relative references of the moved formulas are adjusted to the new row, as in Excel. Numbers and dates come before texts, texts are compared without regard to case and the blank cells are placed last. Formula cells are sorted by their calculated results (call UpdateFormulaResult first for the formulas added in code). The range cannot contain merged cells.
Top
See Also