Posted by Jack on January 31, 2002 6:07 PM
I'm running a macro to do a few different things the last of which is perform a sort on a column (B). For some reason it keeps putting the header row at the of the sorted data. This is what I have for that portion:
Selection.Sort Key1:=Range("B2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Any ideas as to what I'm doing wrong?
Thanks in advance...