J
jc de lorient
Guest
Bonjour le forum
pour bien finir mon projet je souhaiterais "marier" 2 codes VBA
ils fontionnent très bien quand je les utilise seul mais je n'arrive pas a les mélanger
voiçi mon 1er code :
Sub MultiCellCopy()
Dim DataSource(69) As Variant
Dim LastLine As Long
Dim Item As Variant
Dim i As Byte, y As Byte
LastLine = Sheets("Récap").Range("A65536").End(xlUp).Row + 1
For Each Item In Array("i9", "e22", "f22", "e24", "e25", "c16", "g34", "f79", "f35", "f37", _
"f39", "f47", "f49", "f53", "f55", "f57", "f59", "f61", "j35", "j37", _
"j39", "j41", "j43", "j45", "j47", "j49", "j51", "j53", "j55", "j57", _
"j59", "k63", "i65", "k65", "g69", "f71", "f73", "e75", "f75", "g77", _
"i65", "i66", "i67", "i68", "k66", "k67", "k68", "e80", "f80", "i80", "k80", _
"e23", "b28", "g28", "b29", "g29", "b30", "g30", "b31", "g31", "b32", "g32", _
"c17", "c15", "C13", "c10", "i12", "E61", "i15")
DataSource(i) = Sheets("fiche_paye").Range(Item)
i = i + 1
Next
For y = 1 To 69
With Sheets("Récap")
.Cells(LastLine, y) = DataSource(y - 1)
End With
Next
End Sub
je voudrais qu'après ce 1er code celui çi s'effectue :
Range("I9,i12,E22:E25,B28:b32,C17,G28:G32").Select
Range("G28").Activate
ActiveWindow.SmallScroll Down:=45
Range("I9,i12,E22:E25,B28:b32,C17,G28:G32,E75").Select
Range("E75").Activate
Selection.ClearContents
ActiveWindow.SmallScroll Down:=-93
Range("I9").Select
merci a vous tous et très bon début de semaine
JC
pour bien finir mon projet je souhaiterais "marier" 2 codes VBA
ils fontionnent très bien quand je les utilise seul mais je n'arrive pas a les mélanger
voiçi mon 1er code :
Sub MultiCellCopy()
Dim DataSource(69) As Variant
Dim LastLine As Long
Dim Item As Variant
Dim i As Byte, y As Byte
LastLine = Sheets("Récap").Range("A65536").End(xlUp).Row + 1
For Each Item In Array("i9", "e22", "f22", "e24", "e25", "c16", "g34", "f79", "f35", "f37", _
"f39", "f47", "f49", "f53", "f55", "f57", "f59", "f61", "j35", "j37", _
"j39", "j41", "j43", "j45", "j47", "j49", "j51", "j53", "j55", "j57", _
"j59", "k63", "i65", "k65", "g69", "f71", "f73", "e75", "f75", "g77", _
"i65", "i66", "i67", "i68", "k66", "k67", "k68", "e80", "f80", "i80", "k80", _
"e23", "b28", "g28", "b29", "g29", "b30", "g30", "b31", "g31", "b32", "g32", _
"c17", "c15", "C13", "c10", "i12", "E61", "i15")
DataSource(i) = Sheets("fiche_paye").Range(Item)
i = i + 1
Next
For y = 1 To 69
With Sheets("Récap")
.Cells(LastLine, y) = DataSource(y - 1)
End With
Next
End Sub
je voudrais qu'après ce 1er code celui çi s'effectue :
Range("I9,i12,E22:E25,B28:b32,C17,G28:G32").Select
Range("G28").Activate
ActiveWindow.SmallScroll Down:=45
Range("I9,i12,E22:E25,B28:b32,C17,G28:G32,E75").Select
Range("E75").Activate
Selection.ClearContents
ActiveWindow.SmallScroll Down:=-93
Range("I9").Select
merci a vous tous et très bon début de semaine
JC