title: Difference between Application.sum and Application.Sum in Excel 2007 VBA
body: <p>I am writing a macro in VBA to get the sum of the values of a range in Excel 2007. However, whenever I try to type the following code :</p>
  
  <pre><code>sum = Application.Sum(Range("C2:C19")
  </code></pre>
  
  <p>The editor turns it into :</p>
  
  <pre><code>sum = Application.sum(Range("C2:C19")
  </code></pre>
  
  <p>Since I was not sure of the difference between them I tried them out in the Immediate pane with the Print statement. The one with Application.sum gives me the wrong sum while the one with Application.Sum gives me the correct sum. But since the editor automatically changes Sum to sum, I am unable to proceed further. Can anyone please tell me what's going on over here?</p>