Sort Properties

Name

Returns

Description

Header

XlYesNoGuess

Set/Get whether the first row contains header information

MatchCase

Boolean

Set/Get whether the sort is case-sensitive

Orientation

XlSort Orientation

Set/Get the orientation for the sort (Column sort or Row sort)

Rng

Range

Read-only. Returns the range of values on which the sort is performed

SortFields

SortFields

Read-only. Allows for the storing of sort state on workbooks, lists, and autofilters

SortMethod

XlSortMethod

Set/Get the sort method for Chinese languages

0 0

Post a comment