XlYesNoGuess Enumeration
Specifies whether or not the first row contains headers.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlYesNoGuess
'Usage
Dim instance As XlYesNoGuess
public enum XlYesNoGuess
Members
| Member name | Description | |
|---|---|---|
| xlGuess | Excel determines whether there’s a header, and to determine where it is, if there is one. | |
| xlNo | default. (The entire range should be sorted). | |
| xlYes | (The entire range should not be sorted). |
Remarks
Cannot be used when sorting PivotTable reports.