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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
| Range("A11:A93").Select
Selection.Copy
Sheets("synthèse").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("C13").Select
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-72
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
Range("C11:C93").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("synthèse").Select
Range("N2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("L13").Select
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-87
Range("D11:K93").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("synthèse").Select
ActiveWindow.SmallScroll Down:=-9
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-93
Range("H11:K93").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("synthèse").Select
Range("C2:F75").Select
ActiveWindow.SmallScroll Down:=-51
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("H13").Select
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-90
Range("N17").Select
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 11
Range("M11:P93").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("synthèse").Select
Range("G2:J33").Select
ActiveWindow.SmallScroll Down:=-30
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("I13").Select
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-84
Range("Q11:R93").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("synthèse").Select
Range("K2:L26").Select
ActiveWindow.SmallScroll Down:=-33
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("H24").Select
Sheets("Parametres contrôle poids").Select
ActiveWindow.SmallScroll Down:=-84
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
Sheets("synthèse").Select
Range("A2").Select
ActiveWindow.SmallScroll Down:=-6 |
Partager