XlYesNoGuess Enumeration

Specifies whether or not the first row contains headers. Cannot be used when sorting PivotTable reports.

Version Added: Excel 2007

Name

Value

Description

xlGuess

0

Excel determines whether there is a header, and where it is, if there is one.

xlNo

2

Default. The entire range should be sorted.

xlYes

1

The entire range should not be sorted.

Show: