Re : Macros qui bug, simple copier/coller
Sub macros21()
'
' macros21 Macro
' Macro enregistrée le 21/01/2008 par 6809610A
'
' Touche de raccourci du clavier: Ctrl+x
'
ActiveWindow.SmallScroll Down:=33
Range("E70").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-59]C:R[-57]C))-(SUM(R[-59]C[-1]:R[-57]C[-1])))/RC[-2]"
Range("E71").Select
ActiveWindow.Zoom = 40
ActiveWindow.Zoom = 25
ActiveWindow.Zoom = 10
ActiveWindow.Zoom = 25
ActiveWindow.Zoom = 40
ActiveWindow.SmallScroll Down:=-27
Range("E70").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-59]C:R[-57]C))-(SUM(R[-59]C[-1]:R[-57]C[-1])))/RC[-2]"
Range("E71").Select
Sheets("semaine VA (35)").Select
Range("E71").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-54]C:R[-36]C))-(SUM(R[-54]C[-1]:R[-36]C[-1])))/RC[-2]"
Range("E72").Select
Sheets("semaine AB (35)").Select
Range("E71").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-54]C:R[-36]C))-(SUM(R[-54]C[-1]:R[-36]C[-1])))/RC[-2]"
Range("E72").Select
ActiveWindow.SmallScroll Down:=9
Range("E70").Select
Selection.Copy
Range("E74").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-59]C:R[-57]C))-(SUM(R[-59]C[-1]:R[-57]C[-1])))/RC[-2]"
Range("E70").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-59]C:R[-57]C))-(SUM(R[-59]C[-1]:R[-57]C[-1])))/RC[-2]"
Range("E71").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-54]C:R[-36]C))-(SUM(R[-54]C[-1]:R[-36]C[-1])))/RC[-2]"
Range("E74").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-30]C:R[-28]C))-(SUM(R[-59]C[-1]:R[-57]C[-1])))/RC[-2]"
Range("E75").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-26]C:R[-8]C)-(SUM(R[-26]C[-1]:R[-8]C[-1]))/RC[-2]))"
Range("E74").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-30]C:R[-28]C))-(SUM(R[-30]C[-1]:R[-28]C[-1])))/RC[-2]"
Range("E74").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-30]C:R[-28]C))-(SUM(R[-30]C[-1]:R[-28]C[-1])))/RC[-2]"
Range("E74").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-30]C:R[-28]C))-(SUM(R[-30]C[-1]:R[-28]C[-1])))/RC[-2]"
Range("E75").Select
ActiveSheet.Paste
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-26]C:R[-8]C))-(SUM(R[-31]C[-1]:R[-29]C[-1])))/R[-1]C[-2]"
Range("E75").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-26]C:R[-8]C))-(SUM(R[-26]C[-1]:R[-8]C[-1])))/R[-1]C[-2]"
Range("E75").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-26]C:R[-8]C))-(SUM(R[-26]C[-1]:R[-8]C[-1])))/RC[-2]"
Range("E72").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-61]C:R[-59]C,R[-55]C:R[-37]C))-(SUM(R[-61]C[-1]:R[-59]C[-1],R[-55]C[-1]:R[-37]C[-1])))/RC[-2]"
Range("E76").Select
ActiveSheet.Paste
Range("E76").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-32]C:R[-30]C,R[-32]C[-1]:R[-30]C[-1]))-(SUM(R[-65]C[-1]:R[-63]C[-1],R[-59]C[-1]:R[-41]C[-1])))/R[-4]C[-2]"
Range("E72").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-61]C:R[-59]C,R[-55]C:R[-37]C))-(SUM(R[-61]C[-1]:R[-59]C[-1],R[-55]C[-1]:R[-37]C[-1])))/RC[-2]"
Range("E76").Select
ActiveSheet.Paste
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-32]C:R[-30]C,R[-27]C:R[-9]C))-(SUM(R[-32]C[-1]:R[-30]C[-1],R[-27]C[-1]:R[-9]C[-1])))/RC[-2]"
Range("E76").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-32]C:R[-30]C,R[-27]C:R[-9]C))-(SUM(R[-32]C[-1]:R[-30]C[-1],R[-27]C[-1]:R[-9]C[-1])))/RC[-2]"
Range("E76").Select
Selection.Copy
Range("I76").Select
ActiveSheet.Paste
Range("M76").Select
ActiveSheet.Paste
Range("Q76").Select
ActiveSheet.Paste
Range("U76").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-32]C:R[-30]C,R[-27]C:R[-9]C))-(SUM(R[-32]C[-1]:R[-30]C[-1],R[-27]C[-1]:R[-9]C[-1])))/RC[-2]"
Range("E75").Select
Selection.Copy
ActiveSheet.Paste
Application.CutCopyMode = False
Range("E75").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-26]C:R[-8]C))-(SUM(R[-26]C[-1]:R[-8]C[-1])))/RC[-2]"
Range("E75").Select
Selection.Copy
Range("I75").Select
ActiveSheet.Paste
Range("M75").Select
ActiveSheet.Paste
Range("Q75").Select
ActiveSheet.Paste
Range("U75").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
Range("E74").Select
Selection.Copy
Range("I74").Select
ActiveSheet.Paste
Range("M74").Select
ActiveSheet.Paste
Range("Q74").Select
ActiveSheet.Paste
Range("U74").Select
ActiveSheet.Paste
Range("T74").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("U74").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-30]C:R[-28]C))-(SUM(R[-30]C[-1]:R[-28]C[-1])))/RC[-2]"
Range("E72").Select
Selection.Copy
Range("I72").Select
ActiveSheet.Paste
Range("M72").Select
ActiveSheet.Paste
Selection.End(xlToRight).Select
Range("Q72").Select
ActiveSheet.Paste
Range("U72").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-61]C:R[-59]C,R[-55]C:R[-37]C))-(SUM(R[-61]C[-1]:R[-59]C[-1],R[-55]C[-1]:R[-37]C[-1])))/RC[-2]"
Range("E71").Select
Selection.Copy
Range("I71").Select
ActiveSheet.Paste
Range("M71").Select
ActiveSheet.Paste
Range("Q71").Select
ActiveSheet.Paste
Range("U71").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
Range("E70").Select
Selection.Copy
Range("I70").Select
ActiveSheet.Paste
Range("M70").Select
ActiveSheet.Paste
Range("Q70").Select
ActiveSheet.Paste
Range("U70").Select
ActiveSheet.Paste
ActiveSheet.Paste
Application.CutCopyMode = False
Range("M71").Select
ActiveCell.FormulaR1C1 = _
"=((SUM(R[-54]C:R[-36]C))-(SUM(R[-54]C[-1]:R[-36]C[-1])))/RC[-2]"
Range("M72").Select
End Sub
Voilà!