Sort and Specify that you have a header row

[Darin Kramer]

Hi There,

I want to specify that I have a header row.
Below is the VB

Selection.Sort Key1:=Range("C2"), Order1:=xlDescending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

So I know I need to change header from xlGuess, but what do I change it
to???

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***

[Nicky]

Hi
try xlYes

[Darin Kramer]

Thanks Nicky!

*** Sent via Developersdex http://www.developersdex.com ***