Sort Object Members

Office Developer Center

Printer Friendly Version

Send

MSDN Library

Office Development

2007 Microsoft Office System

Excel 2007 Developer Reference

Excel Object Model Reference

Sort Object Members

Switch on low bandwidth view

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.

© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement