Поделиться через

Sort Members (Excel)

  • Статья

Represents a sort of a range of data.

Methods

Name

Description

Apply

Sorts the range based on the currently applied sort states.

SetRange

Sets the starting and ending character positions for Sort object.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft 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 Long.

Header

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

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 XlSortOrientation.

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 XlSortMethod.