title: How to create a sum function in VBA
body: <p>How can one use a sum function in VBA, i am trying the below piece but does not seem to work.</p>
  
  <pre><code>temp=Application.run("Sum",range("A1").value,range("A2").value)
  Range("A1").value=temp
  </code></pre>
  
  <p>i.e
  If A1=3 and A2=3
  I want the end value to be 9.</p>