Sort and Specify that you have a header row
 

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 ***

Sort and Specify that you have a header row
 

Hi
try xlYes


--
Nicky


------------------------------------------------------------------------
Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
View this thread: http://www.excelforum.com/showthread...hreadid=380798

Sort and Specify that you have a header row
 

Thanks Nicky!

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