SortFields Members (Excel)

  • Article

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

Methods

Name

Description

Add

Creates a new sort field and returns a SortFields object.

Clear

Clears all the SortFields objects.

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.

Count

Returns the number of objects in the collection. Read-only Long.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Item

Returns a SortField object that represents a collection of items that can be sorted in a workbook. Read-only.

Parent

Returns the parent object for the specified object. Read-only.