1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Sub Macro2()
Application.ScreenUpdating = False
For i = 1 To 6
Sheets("cas" & i).Range("AW60:AW75").Copy
Sheets("Result").Range("R" & i + 1).PasteSpecial Paste:=xlPasteFormulas, Transpose:=True
Selection.Replace What:="=", Replacement:="=Cas" & i & "!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="/", Replacement:="/Cas" & i & "!", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Next
Application.CutCopyMode = False
End Sub |