Sort Properties (Excel)

Office 2013

Published: July 16, 2012

This object has the following 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

Returns the SortFields object that represents the collection of sort fields associated with the Sort object. Read-only.

SortMethod

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

Community Additions

ADD
Show:
© 2014 Microsoft