Share via

XlYesNoGuess Enumeration

  • Article

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

Version Information
 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.