Sorting is done by the specified column.
In your case column C.
Using xlYes for the header option means that the first row
of the data will be Excluded from the sort.
Using the xlNo option Includes the first row in the sort.
I never rely on the xlGuess option.
Portland, Oregon USA
(Special Sort Excel add-in; two dozen additional ways to sort)
I looked through the forum but did not find an answer.
The header information in my spreadsheet is in row 2.
Excel has 3 options for header row: Yes, No, and Guess. None of these
work on my worksheet to use the second row to sort by.
Selection.Sort Key1:=Range("C2"), Order1:=xlDescending,
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
I have a work around that I adapted from Tom Ogilvy:
Remove the blank row."
I added the code for that and it works fine. It feels like there
should be a way to say "Use Row 2 as Header Row".