Sort Members
Include Protected Members
Include Inherited Members
Represents a sort of a range of data.
The Sort type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
Application | When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object. Read-only. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. Read-only. |
|
Header | Specifies whether the first row contains header information. Read/write. |
|
MatchCase | Set to True to perform a case-sensitive sort or set to False to perform non-case sensitive sort. Read/write. |
|
Orientation | Specifies the orientation for the sort. Read/write. |
|
Parent | Returns the parent object for the specified object. Read-only. |
|
Rng | Return the range of values on which the sort is performed. Read-only. |
|
SortFields | Stores the sort state for workbooks, lists, and autofilters. Read-only. |
|
SortMethod | Specifies the sort method for Chinese languages. Read/write. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Apply | Sorts the range based on the currently applied sort states. |
|
SetRange | Sets the starting and ending character positions for the Sort object. |
Top