V
virginie
Guest
Bonjour le forum,
J’ai fait une macro a l’aide de l’enregistreur.je souhaite reproduire
La même action avec les données actualisées lors du premier enregistrement
Quelle instruction, (s) doit figurer pour que cela fonctionne
Sub MacroDécalerValeurs()
'
' Macro enregistrée le 22/08/2003
'
'
Range("A2723:EH2740").Select
Selection.Copy
Range("A2741").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll ToRight:=7
ActiveWindow.SmallScroll Down:=9
Range("T2741").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1052]C[-18]+0.8*'Feuil1(4)'!R[1052]C[-11]"
Range("T2742").Select
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1051]C[-18]+0.7*'Feuil1(4)'!R[1051]C[-4]"
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1051]C[-18]+0.7*'Feuil1(4)'!R[1051]C[-4]"
Range("T2743").Select
ActiveCell.FormulaR1C1 = _
"=0.4*'Feuil1(4)'!R[1050]C[-18]+0.6*'Feuil1(4)'!R[1050]C[3]"
Range("T2744").Select
ActiveCell.FormulaR1C1 = _
"=0.5*'Feuil1(4)'!R[1049]C[-18]+0.5*'Feuil1(4)'!R[1049]C[10]"
Range("T2745").Select
ActiveCell.FormulaR1C1 = _
"=0.6*'Feuil1(4)'!R[1048]C[-18]+0.4*'Feuil1(4)'!R[1048]C[17]"
Range("T2746").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1047]C[-18]+0.3*'Feuil1(4)'!R[1047]C[24]"
Range("T2747").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1046]C[-18]+0.3*'Feuil1(4)'!R[1046]C[24]"
Range("T2748").Select
ActiveCell.FormulaR1C1 = _
"=0.9*'Feuil1(4)'!R[1045]C[-18]+0.1*'Feuil1(4)'!R[1045]C[38]"
Range("T2741:T2748").Select
Selection.AutoFill Destination:=Range("T2741:Z2748"), Type:=xlFillDefault
Range("T2741:Z2748").Select
Range("T2750").Select
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1044]C[-18]+0.8*'Feuil1(4)'!R[1044]C[-11]"
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1044]C[-18]+0.8*'Feuil1(4)'!R[1044]C[-11]"
Range("T2751").Select
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1043]C[-18]+0.7*'Feuil1(4)'!R[1043]C[-4]"
Range("T2752").Select
ActiveCell.FormulaR1C1 = _
"=0.4*'Feuil1(4)'!R[1042]C[-18]+0.6*'Feuil1(4)'!R[1042]C[3]"
Range("T2753").Select
ActiveCell.FormulaR1C1 = _
"=0.5*'Feuil1(4)'!R[1041]C[-18]+0.5*'Feuil1(4)'!R[1041]C[10]"
Range("T2754").Select
ActiveCell.FormulaR1C1 = _
"=0.6*'Feuil1(4)'!R[1040]C[-18]+0.4*'Feuil1(4)'!R[1040]C[17]"
Range("T2755").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1039]C[-18]+0.3*'Feuil1(4)'!R[1039]C[24]"
Range("T2756").Select
ActiveWindow.SmallScroll Down:=3
ActiveCell.FormulaR1C1 = _
"=0.8*'Feuil1(4)'!R[1038]C[-18]+0.2*'Feuil1(4)'!R[1038]C[31]"
Range("T2757").Select
ActiveCell.FormulaR1C1 = _
"=0.9*'Feuil1(4)'!R[1037]C[-18]+0.1*'Feuil1(4)'!R[1037]C[38]"
Range("T2750:T2757").Select
Selection.AutoFill Destination:=Range("T2750:Z2757"), Type:=xlFillDefault
Range("T2750:Z2757").Select
ActiveWindow.SmallScroll ToRight:=7
Range("AJ2741").Select
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1050]C[-19]+0.8*Feuil2!R[1050]C[42]"
Range("AJ2742").Select
ActiveCell.FormulaR1C1 = "=0.3*Feuil2!R[1049]C[-19]+0.7*Feuil2!R[1049]C[35]"
Range("AJ2743").Select
ActiveCell.FormulaR1C1 = "=0.4*Feuil2!R[1048]C[-19]+0.6*Feuil2!R[1048]C[28]"
Range("AJ2744").Select
ActiveCell.FormulaR1C1 = "=0.5*Feuil2!R[1047]C[-19]+0.5*Feuil2!R[1047]C[21]"
Range("AJ2745").Select
ActiveCell.FormulaR1C1 = "=0.6*Feuil2!R[1046]C[-19]+0.4*Feuil2!R[1046]C[14]"
Range("AJ2746").Select
ActiveCell.FormulaR1C1 = "=0.7*Feuil2!R[1045]C[-19]+0.3*Feuil2!R[1045]C[7]"
Range("AJ2747").Select
ActiveCell.FormulaR1C1 = "=0.8*Feuil2!R[1044]C[-19]+0.2*Feuil2!R[1044]C"
Range("AJ2748").Select
ActiveCell.FormulaR1C1 = "=0.9*Feuil2!R[1043]C[-19]+0.1*Feuil2!R[1043]C[-7]"
Range("AJ2741:AJ2748").Select
Selection.AutoFill Destination:=Range("AJ2741:AP2748"), Type:=xlFillDefault
Range("AJ2741:AP2748").Select
Range("AJ2750").Select
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1042]C[-19]+0.8*Feuil2!R[1042]C[42]"
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1042]C[-19]+0.8*Feuil2!R[1042]C[42]"
Range("AJ2751").Select
ActiveCell.FormulaR1C1 = "=0.3*Feuil2!R[1041]C[-19]+0.7*Feuil2!R[1041]C[35]"
Range("AJ2752").Select
ActiveCell.FormulaR1C1 = "=0.4*Feuil2!R[1040]C[-19]+0.6*Feuil2!R[1040]C[28]"
Range("AJ2753").Select
ActiveCell.FormulaR1C1 = "=0.5*Feuil2!R[1039]C[-19]+0.5*Feuil2!R[1039]C[21]"
Range("AJ2754").Select
ActiveCell.FormulaR1C1 = "=0.6*Feuil2!R[1038]C[-19]+0.4*Feuil2!R[1038]C[14]"
Range("AJ2755").Select
ActiveCell.FormulaR1C1 = "=0.7*Feuil2!R[1037]C[-19]+0.3*Feuil2!R[1037]C[7]"
Range("AJ2756").Select
ActiveCell.FormulaR1C1 = "=0.8*Feuil2!R[1036]C[-19]+0.2*Feuil2!R[1036]C"
Range("AJ2757").Select
ActiveCell.FormulaR1C1 = "=0.9*Feuil2!R[1035]C[-19]+0.1*Feuil2!R[1035]C[-7]"
Range("AJ2750:AJ2757").Select
Selection.AutoFill Destination:=Range("AJ2750:AP2757"), Type:=xlFillDefault
Range("AJ2750:AP2757").Select
Range("AB2741").Select
Sheets("Feuil6.1").Select
End Sub
Merci pour l’aide que vous voulez bien m’apporter.
Virginie
J’ai fait une macro a l’aide de l’enregistreur.je souhaite reproduire
La même action avec les données actualisées lors du premier enregistrement
Quelle instruction, (s) doit figurer pour que cela fonctionne
Sub MacroDécalerValeurs()
'
' Macro enregistrée le 22/08/2003
'
'
Range("A2723:EH2740").Select
Selection.Copy
Range("A2741").Select
ActiveSheet.Paste
ActiveWindow.SmallScroll ToRight:=7
ActiveWindow.SmallScroll Down:=9
Range("T2741").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1052]C[-18]+0.8*'Feuil1(4)'!R[1052]C[-11]"
Range("T2742").Select
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1051]C[-18]+0.7*'Feuil1(4)'!R[1051]C[-4]"
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1051]C[-18]+0.7*'Feuil1(4)'!R[1051]C[-4]"
Range("T2743").Select
ActiveCell.FormulaR1C1 = _
"=0.4*'Feuil1(4)'!R[1050]C[-18]+0.6*'Feuil1(4)'!R[1050]C[3]"
Range("T2744").Select
ActiveCell.FormulaR1C1 = _
"=0.5*'Feuil1(4)'!R[1049]C[-18]+0.5*'Feuil1(4)'!R[1049]C[10]"
Range("T2745").Select
ActiveCell.FormulaR1C1 = _
"=0.6*'Feuil1(4)'!R[1048]C[-18]+0.4*'Feuil1(4)'!R[1048]C[17]"
Range("T2746").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1047]C[-18]+0.3*'Feuil1(4)'!R[1047]C[24]"
Range("T2747").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1046]C[-18]+0.3*'Feuil1(4)'!R[1046]C[24]"
Range("T2748").Select
ActiveCell.FormulaR1C1 = _
"=0.9*'Feuil1(4)'!R[1045]C[-18]+0.1*'Feuil1(4)'!R[1045]C[38]"
Range("T2741:T2748").Select
Selection.AutoFill Destination:=Range("T2741:Z2748"), Type:=xlFillDefault
Range("T2741:Z2748").Select
Range("T2750").Select
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1044]C[-18]+0.8*'Feuil1(4)'!R[1044]C[-11]"
ActiveCell.FormulaR1C1 = _
"=0.2*'Feuil1(4)'!R[1044]C[-18]+0.8*'Feuil1(4)'!R[1044]C[-11]"
Range("T2751").Select
ActiveCell.FormulaR1C1 = _
"=0.3*'Feuil1(4)'!R[1043]C[-18]+0.7*'Feuil1(4)'!R[1043]C[-4]"
Range("T2752").Select
ActiveCell.FormulaR1C1 = _
"=0.4*'Feuil1(4)'!R[1042]C[-18]+0.6*'Feuil1(4)'!R[1042]C[3]"
Range("T2753").Select
ActiveCell.FormulaR1C1 = _
"=0.5*'Feuil1(4)'!R[1041]C[-18]+0.5*'Feuil1(4)'!R[1041]C[10]"
Range("T2754").Select
ActiveCell.FormulaR1C1 = _
"=0.6*'Feuil1(4)'!R[1040]C[-18]+0.4*'Feuil1(4)'!R[1040]C[17]"
Range("T2755").Select
ActiveCell.FormulaR1C1 = _
"=0.7*'Feuil1(4)'!R[1039]C[-18]+0.3*'Feuil1(4)'!R[1039]C[24]"
Range("T2756").Select
ActiveWindow.SmallScroll Down:=3
ActiveCell.FormulaR1C1 = _
"=0.8*'Feuil1(4)'!R[1038]C[-18]+0.2*'Feuil1(4)'!R[1038]C[31]"
Range("T2757").Select
ActiveCell.FormulaR1C1 = _
"=0.9*'Feuil1(4)'!R[1037]C[-18]+0.1*'Feuil1(4)'!R[1037]C[38]"
Range("T2750:T2757").Select
Selection.AutoFill Destination:=Range("T2750:Z2757"), Type:=xlFillDefault
Range("T2750:Z2757").Select
ActiveWindow.SmallScroll ToRight:=7
Range("AJ2741").Select
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1050]C[-19]+0.8*Feuil2!R[1050]C[42]"
Range("AJ2742").Select
ActiveCell.FormulaR1C1 = "=0.3*Feuil2!R[1049]C[-19]+0.7*Feuil2!R[1049]C[35]"
Range("AJ2743").Select
ActiveCell.FormulaR1C1 = "=0.4*Feuil2!R[1048]C[-19]+0.6*Feuil2!R[1048]C[28]"
Range("AJ2744").Select
ActiveCell.FormulaR1C1 = "=0.5*Feuil2!R[1047]C[-19]+0.5*Feuil2!R[1047]C[21]"
Range("AJ2745").Select
ActiveCell.FormulaR1C1 = "=0.6*Feuil2!R[1046]C[-19]+0.4*Feuil2!R[1046]C[14]"
Range("AJ2746").Select
ActiveCell.FormulaR1C1 = "=0.7*Feuil2!R[1045]C[-19]+0.3*Feuil2!R[1045]C[7]"
Range("AJ2747").Select
ActiveCell.FormulaR1C1 = "=0.8*Feuil2!R[1044]C[-19]+0.2*Feuil2!R[1044]C"
Range("AJ2748").Select
ActiveCell.FormulaR1C1 = "=0.9*Feuil2!R[1043]C[-19]+0.1*Feuil2!R[1043]C[-7]"
Range("AJ2741:AJ2748").Select
Selection.AutoFill Destination:=Range("AJ2741:AP2748"), Type:=xlFillDefault
Range("AJ2741:AP2748").Select
Range("AJ2750").Select
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1042]C[-19]+0.8*Feuil2!R[1042]C[42]"
ActiveCell.FormulaR1C1 = "=0.2*Feuil2!R[1042]C[-19]+0.8*Feuil2!R[1042]C[42]"
Range("AJ2751").Select
ActiveCell.FormulaR1C1 = "=0.3*Feuil2!R[1041]C[-19]+0.7*Feuil2!R[1041]C[35]"
Range("AJ2752").Select
ActiveCell.FormulaR1C1 = "=0.4*Feuil2!R[1040]C[-19]+0.6*Feuil2!R[1040]C[28]"
Range("AJ2753").Select
ActiveCell.FormulaR1C1 = "=0.5*Feuil2!R[1039]C[-19]+0.5*Feuil2!R[1039]C[21]"
Range("AJ2754").Select
ActiveCell.FormulaR1C1 = "=0.6*Feuil2!R[1038]C[-19]+0.4*Feuil2!R[1038]C[14]"
Range("AJ2755").Select
ActiveCell.FormulaR1C1 = "=0.7*Feuil2!R[1037]C[-19]+0.3*Feuil2!R[1037]C[7]"
Range("AJ2756").Select
ActiveCell.FormulaR1C1 = "=0.8*Feuil2!R[1036]C[-19]+0.2*Feuil2!R[1036]C"
Range("AJ2757").Select
ActiveCell.FormulaR1C1 = "=0.9*Feuil2!R[1035]C[-19]+0.1*Feuil2!R[1035]C[-7]"
Range("AJ2750:AJ2757").Select
Selection.AutoFill Destination:=Range("AJ2750:AP2757"), Type:=xlFillDefault
Range("AJ2750:AP2757").Select
Range("AB2741").Select
Sheets("Feuil6.1").Select
End Sub
Merci pour l’aide que vous voulez bien m’apporter.
Virginie