View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default 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 ***