XlYesNoGuess Enumeration (Excel)

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.