Skip to main content

XlYesNoGuess enumeration

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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>