1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| Range("A1:B10").Select
Selection.Sort Key1:=Range("B7"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
a = Range("B6").Value
b = Range("B5").Value
c = Range("B4").Value
d = Range("B3").Value
e = Range("B2").Value
Range("A1:B10").Select
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
a = Application.WorksheetFunction.Match(a, Range("B:B"), 0)
b = Application.WorksheetFunction.Match(b, Range("B:B"), 0)
c = Application.WorksheetFunction.Match(c, Range("B:B"), 0)
d = Application.WorksheetFunction.Match(d, Range("B:B"), 0)
e = Application.WorksheetFunction.Match(e, Range("B:B"), 0)
ActiveSheet.ChartObjects("Graphique 1").Activate |
Partager