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
|
Sub Transfert_données()
Dim MaPlage As Range
With ThisWorkbook.Worksheets("donnéesbase")
Set MaPlage = .Range("B2")
End With
MaPlage.copy
ActiveSheet.Paste Destination:=Workbooks("Climacro").Worksheets("Données").Range("C24:C24")
Range("C24:C24").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
With ThisWorkbook.Worksheets("CLMD-5-Liste Locaux")
Set MaPlage = .Range("D2:D1000")
End With
MaPlage.copy
ActiveSheet.Paste Destination:=Workbooks("Climacro").Worksheets("Liste Locaux").Range("E10:E1000")
Range("E10:E1000").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub |
Partager