XlYesNoGuess XlYesNoGuess XlYesNoGuess Enum

Definition

Specifies whether or not the first row contains headers.

public enum class XlYesNoGuess
public enum XlYesNoGuess
Public Enum XlYesNoGuess
Inheritance
XlYesNoGuessXlYesNoGuessXlYesNoGuess

Fields

xlGuess xlGuess xlGuess 0

Excel determines whether there’s a header, and to determine where it is, if there is one.

xlNo xlNo xlNo 2

default. (The entire range should be sorted).

xlYes xlYes xlYes 1

(The entire range should not be sorted).

Remarks

Cannot be used when sorting PivotTable reports.

Applies to