Sort.SetRange Method
| Excel Developer Reference |
Sets the starting and ending character positions for Sort object.
Version Information
Version Added: Excel 2007
Syntax
expression.SetRange(Rng)
expression A variable that represents a Sort object.
Syntax
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Rng | Required | Range | Specifies the range for the Sort collection. |
.gif "Bb210561.vs_note(en-us,office.12).gif") Note |
|---|
| SetRange can only be used when applying a sort to a sheet range, and cannot be used if the range is within a table. |
See Also