XlYesNoGuess Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: