Sum()

Hi everyone,

I’m developing an application in Microsoft Excel. I did some research, and I found out that you have to use “Macros” within Excel. I was wondering, how can you add numbers dynamically using Visual basic?

Let’s say I have random numbers in A:1 and some more random numbers in A:5. How can I get the total in A:6?

MyTotal = Application.Sum(Range("A1:A100")) 
' returns the total of the values in A1:A100 in the active worksheet. 

I tried something like this, but It wouldn’t compile.