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)

Usage

Dim xlYesNoGuess1 As XlYesNoGuess = XlYesNoGuess.xlGuess

Syntax

Public Enum XlYesNoGuess
public enum XlYesNoGuess
public enum class XlYesNoGuess
public enum 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.

Platforms

Development Platforms

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

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace