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