Option Explicit
Option Base 0
Private Sub TransfertSem()
'pour le transfert dans 52 pages
Dim acopier As Variant
Dim vers As Variant
Dim i As Integer
Dim n As Integer
Application.ScreenUpdating = False
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
acopier = Array("C8:F12", "C18:F22", "J18", "J26", "K8:O26", "K32:O39", "R11:R13", "R16:R17", "R30:R36", "R43:R47", "S8:W17", "S23:W47")
vers = Array("C8", "C18", "J18", "J26", "K8", "K32", "R11", "R16", "R30", "R43", "S8", "S23")
For i = 1 To 52
If i < 10 Then i = "0" & i
For n = 0 To UBound(acopier)
Workbooks("source.xls").Sheets("sem" & i).Range(acopier(n)).Copy Destination:=Workbooks("version_new.xls").Sheets("sem" & i).Range(vers(n))
Next n
Next i
Application.ScreenUpdating = True
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
End Sub