title: Trying to do maths with vba but need to keep cells current formulas
body: <p>I am trying to create code and understand how I can keep the cells current formulas intact. I want to be able to create a new formula where if a cell had a formula such as (=E4+E5) if I add it with another cell again such as E5 it gives the output = E4+E5+E5. My current code gives me the output E4+E512 which I really don't understand why. I am currently replacing the &quot;=&quot; sign that comes with when taking a cell.formula  so that my output is not =E4+=E5+E5</p>
  <p>current code:</p>
  <pre><code>Public Sub blokkie_toets()
  Dim cell_for As Range
  Dim cell_new As Range
  
  Set cell_for = Range(&quot;E7&quot;)
  Set cell_new = Range(&quot;E4&quot;)
  
  If Left(cell_for.Formula, 1) = &quot;=&quot; Then
        ActiveCell = Replace(cell_for.Formula, &quot;=&quot;, &quot;&quot;) + cell_new.Formula
  End If
  
  
  
  End Sub
  </code></pre>
  <p><a href="https://i.stack.imgur.com/fGNrW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fGNrW.png" alt="enter image description here" /></a></p>