Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
XlYesNoGuess Enumeration
Collapse the table of content
Expand the table of content

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)

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

Community Additions

© 2015 Microsoft