Welcome Sign in
Office Developer Center
Printer Friendly Version      Send     
Click to Rate and Give Feedback
MSDN
MSDN Library
Office Development
Excel 2007
Sort Object
 Sort Object Members
Sort Object Members

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


© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker