Sum in VBA
Sorry I got the range wong. It should read
ActiveSheet.Range("A17") = Application.Sum(ActiveSheet.Range("A4:A16"))
Oops...
"Jim Thomlinson" wrote:
Here is the code:
ActiveSheet.Range("A17") = Application.Sum(ActiveSheet.Range("A1:A16"))
This inserts the total. Not a formula.
HTH
"Susan Hayes" wrote:
Hello
How can I sum up for example A4 through A16 and have the total appear in A17, i.e., A17 = SUM(A4:A16)
What is the VBA syntax to get the above.
Thank you,
Jen T.
|