0 out of 3 rated this helpful - Rate this topic

SortFields Object

Office 2007

The SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters.

Version Information
Version Added: Excel 2007

Remarks

The object contains properties to add, count, sort, and remove SortField objects.

Example

Visual Basic for Applications
`ActiveWorksheet.SortFields.Add Key:=Range("A1"), Order:=xlDescending ActiveWorksheet.SortFields.Add Key:=Range("B1"), Order:=xlDescending ActiveWorksheet.SortFields.Sort Header:=xlGuess`

See Also

Excel Object Model Reference
SortFields Object Members

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ