Thread: Macro to copy formula and add it to another formula

I'm looking to find or write a macro that takes the formula in an existing cell, pulls the formula from another cell and adds the two together. For example: in cell r3c7 I have formulaA, I want the macro to return FormalaA + FormulaB (which exists in cell r3a3). without altering the contents in r3a3. Then I need this to repeat for each cell withing the given range. Another option is to have this macro return FormulaA + r3a3, as long as r3a3 remains a variable value that will change as the formula in r3a3 returns different results.

You might want to remove the extra = operator

Cells(1, 3).Formula = Cells(1, 1).Formula & "+" & Right(Cells(1, 2).Formula, Len(Cells(1, 2).Formula) - 1)