This documentation is archived and is not being maintained.

XlYesNoGuess Enumeration 

Specifies whether or not the first row contains headers.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlYesNoGuess1 As XlYesNoGuess = XlYesNoGuess.xlGuess

Public Enum XlYesNoGuess
public enum XlYesNoGuess
public enum XlYesNoGuess

Member nameDescription
xlGuessExcel determines whether there’s a header, and to determine where it is, if there is one.
xlNodefault. (The entire range should be sorted).
xlYes(The entire range should not be sorted).

Cannot be used when sorting PivotTable reports.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms