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 27 28 29 30 31 32 33 34 35 36 37 38
| arrCentre = Array(Split(ordreCentre, ","))
arrSejour = Array(Split(ordreSejour, ","))
Application.AddCustomList ListArray:=arrCentre
Application.AddCustomList ListArray:=arrSejour
CentreNum = Application.GetCustomListNum(arrCentre)
SejourNum = Application.GetCustomListNum(arrSejour)
ws_globale.Sort.SortFields.Clear
ws_globale.Sort.SortFields.Add _
Key:=range("B2:B337"), _
SortOn:=xlSortOnValues, _
Order:=xlAscending, _
CustomOrder:=CentreNum, _
DataOption:=xlSortNormal
ws_globale.Sort.SortFields.Add _
Key:=range("C2:C" & listeGlobale.hauteur + 1), _
SortOn:=xlSortOnValues, _
Order:=xlAscending, _
CustomOrder:=SejourNum, _
DataOption:=xlSortNormal
ws_globale.Sort.SortFields.Add _
Key:=range("G2:G" & listeGlobale.hauteur + 1), _
SortOn:=xlSortOnValues, _
Order:=xlAscending, _
DataOption:=xlSortNormal
ws_globale.Sort.SortFields.Add _
Key:=range("H2:H" & listeGlobale.hauteur + 1), _
SortOn:=xlSortOnValues, _
Order:=xlAscending, _
DataOption:=xlSortNormal
With ws_globale.Sort
.SetRange ws_globale.Cells
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With |
Partager