Sort Sort Sort Interface


Represents a sort of a range of data.

public interface class Sort
public interface Sort
Public Interface Sort


Application Application 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 Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only.

Header Header Header

Specifies whether the first row contains header information. Read/write.

MatchCase MatchCase MatchCase

Set to True to perform a case-sensitive sort or set to False to perform non-case sensitive sort. Read/write.

Orientation Orientation Orientation

Specifies the orientation for the sort. Read/write.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

Rng Rng Rng

Return the range of values on which the sort is performed. Read-only.

SortFields SortFields SortFields

Stores the sort state for workbooks, lists, and autofilters. Read-only.

SortMethod SortMethod SortMethod

Specifies the sort method for Chinese languages. Read/write.


Apply() Apply() Apply()

Sorts the range based on the currently applied sort states.

SetRange(Range) SetRange(Range) SetRange(Range)

Sets the starting and ending character positions for the Sort object.

Applies to