XlYesNoGuess Enumeration
Specifies whether or not the first row contains headers. Cannot be used when sorting PivotTable reports.
Version Information
Version Added: Excel
| 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. |