Sort Method Example
This example sorts the range A1:F10 in descending order based on column 2.
Set c = Spreadsheet1.Constants Spreadsheet1.Range("a1:f10").Sort 2, c.ssDescending