Henrich
12/14/2006 3:57:00 PM
Thanks.
"Bill Pfister" wrote:
> Henrich,
>
> The order of the sort keys that you choose determines which column gets
> priority. The following code sorts B3:E6, using columns D and E as the sort
> keys, with column D having priority.
>
> Regards,
> Bill
>
>
> Range("B3:E6").Select
> Selection.Sort _
> Key1:=Range("D3"), Order1:=xlAscending, _
> Key2:=Range("E3"), Order2:=xlAscending, _
> Header:=xlGuess, OrderCustom:=1, MatchCase:= _
> False, Orientation:=xlTopToBottom, _
> DataOption1:=xlSortNormal, _
> DataOption2:=xlSortNormal
>
>
>
> "Henrich" wrote:
>
> > Hi,
> >
> > i have data in cells B3 to E6. In column D and E are numbers but i want that
> > column D has the priority.
> >
> > For bether explanation: it ist chart wit points (column D) and score
> > (columnE) like in sport.
> >
> > Thanks
> > Henrich