Sort.SetRange Method (Excel)
Sets the range over which the sort occurs.
Version Information
Version Added: Excel 2007
Syntax
expression .SetRange(Rng)
expression A variable that represents a Sort object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Rng |
Required |
Range |
Specifies the range over which the sort represented by the Sort object occurs. |
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.