| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlYesNoGuess enumeration (Excel) |
|
c4c8e9b1-ad12-5c63-da32-60d410915452 |
06/08/2017 |
medium |
Specifies whether or not the first row contains headers. Cannot be used when sorting PivotTable reports.
| 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. |
[!includeSupport and feedback]