Sub Trigodet()
Dim NbLig As Integer
Dim NbLig2 As Integer
Dim NbLig3 As Integer
NbLig = Application.WorksheetFunction.Count(Range("A3:A50")) + 2 'Si nblig=24
NbLig2 = (NbLig + 2) / 2 ' = 12
NbLig3 = NbLig2 + 1 ' = 13
Range(Cells(3, 1), Cells(NbLig, 2)).Select
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Add Key:=Range(Cells(3, 2), Cells(NbLig, 2)) _
, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("PLAN donnée").Sort
.SetRange Range(Cells(3, 1), Cells(NbLig, 2))
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range(Cells(3, 1), Cells(NbLig2, 1)).Select
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Add Key:=Range(Cells(3, 1), Cells(NbLig2, 1)) _
, SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("PLAN donnée").Sort
.SetRange Range(Cells(3, 1), Cells(NbLig2, 1))
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range(Cells(NbLig3, 1), Cells(NbLig, 1)).Select
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Add Key:=Range(Cells(NbLig3, 1), Cells(NbLig, 1)) _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("PLAN donnée").Sort
.SetRange Range(Cells(NbLig3, 1), Cells(NbLig, 1))
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range(Cells(3, 2), Cells(NbLig2, 2)).Select
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("PLAN donnée").Sort.SortFields.Add Key:=Range(Cells(3, 2), Cells(NbLig2, 2)) _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("PLAN donnée").Sort
.SetRange Range(Cells(3, 2), Cells(NbLig2, 2))
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End Sub