This documentation is archived and is not being maintained.

XlYesNoGuess Enumeration

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

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlGuess0Excel determines whether there is a header, and where it is, if there is one.
xlNo2Default. The entire range should be sorted.
xlYes1The entire range should not be sorted.


Show: