XlYesNoGuess Enumeration
Collapse the table of content
Expand the table of content

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

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.

© 2015 Microsoft