title: SQRT formula in VBA
body: <p>Can someone help me get the correct formula? </p>
  
  <p>I want to calculate the following:</p>
  
  <p>SQRT((Rng2^2) + (Rng4^2)) </p>
  
  <p>Here is my code but it is not working</p>
  
  <pre><code>Cells(LastRow + 1, LastCol + 4) = "=SQRT((Rng2.Address)^2 &amp; " + " &amp; (Rng4.Address)^2)"
  </code></pre>