xlYesNoGuess

Specifies whether or not the first row contains headers.

xlGuessExcel determines whether there is a header, and where it is, if there is one (0)
xlNoDefault
The entire range should be sorted (2)
xlYesThe entire range should not be sorted (1)

xlGuess
Excel determines whether there is a header, and where it is, if there is one (0)
xlNo
Default
The entire range should be sorted (2)
xlYes
The entire range should not be sorted (1)


© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top