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 79 80 81 82 83 84 85 86 87
| Private Sub CommandButton1_Click()
'Insertion Pirelli
If CheckBox8.Value = True Then
Sheets("Données").Select
Rows("63:73").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion continental
If CheckBox7.Value = True Then
Sheets("Données").Select
Rows("54:62").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion Michelin
If CheckBox6.Value = True Then
Sheets("Données").Select
Rows("44:53").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion VOLVO
If CheckBox5.Value = True Then
Sheets("Données").Select
Rows("36:43").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion FIAT
If CheckBox4.Value = True Then
Sheets("Données").Select
Rows("21:27").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion BMW
If CheckBox3.Value = True Then
Sheets("Données").Select
Rows("28:35").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion Puissance 6Cv
If CheckBox2.Value = True Then
Sheets("Données").Select
Rows("14:20").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
'Insertion Puissance 5Cv
If CheckBox1.Value = True Then
Sheets("Données").Select
Rows("5:13").Select
Selection.Copy
Sheets("Test MAcro").Select
Selection.Insert Shift:=xlDown
End If
Unload Me
End Sub |
Partager