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
|
Sub CLST1()
'
' CLS TOUR1 POULE1
'
Application.ScreenUpdating = False
'Application.EnableEvents = False ' => désactive les événements
Call DEpro
'''''''''''''''''''''''''''''''''''''''''
Dim I As Integer
Dim Ligne As Integer
Dim Col As Integer
Ligne = 6
Col = 4
Sheets("TOUR1").Select
For I = 1 To 10
Range(Cells(Ligne, Col), Cells(Ligne + 3, Col + 4)).Select
Selection.Copy
Cells(Ligne + 11, Col).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
With ActiveSheet
Range(Cells(Ligne + 11, Col), Cells(Ligne + 14, Col + 4)).Sort key1:=Cells(Ligne + 11, Col + 1), key2:=(Cells(Ligne + 11, Col + 4)), key3:=Cells(Ligne + 11, Col + 1), order1:=xlDescending, Header:=xlYes
End With
Range(Cells(Ligne + 11, Col + 1), Cells(Ligne + 14, Col + 4)).ClearContents
Cells(Ligne + 2, 13).Select
Col = Col + 9
Next
End Sub |
Partager