1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub Valider()
' Enregistrement_Données
'
Sheets("Feuille1").Activate
Rows("13:13").Select
Selection.Insert Shift:=xlDown
Range("A13").Select
Sheets("Feuille2").Select
Range("Z2:AZ2").Select
Selection.Copy
Sheets("Feuille1").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Sheets("Feuille2").Select
Range("B6,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17,B18,B19,B20,B21,B22,B23,B24,B25").Select
Selection.ClearContents
Range("B6").Select
End Sub |
Partager