1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
Sub Saisie_Entree2()
Dim ListeCellules As Variant
Dim I As Integer, J As Integer
Application.ScreenUpdating = False
ListeCellules = Array("d4", "d6", "d8", "d10", "d12", "d14", "d16", "d18", "d20", "d22", "d24", "d26", "g4", "g6", "g8", "g10", "g12", "g14", "g16", "g18", "g20", "g22", "g24", "g26", "j4", "j6", "j8", "j10", "j12", "j14", "j16", "j18", "j20", "j22", "j24", "j26")
Sheets("Base").Rows("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
J = 1
For I = LBound(ListeCellules) To UBound(ListeCellules)
Sheets("Base").Cells(2, J) = Sheets("Saisie").Range(ListeCellules(I)).Value
Sheets("Saisie").Range(ListeCellules(I)).ClearContents
J = J + 1
Next I
Application.ScreenUpdating = True
End Sub |
Partager