Cumulative Sum of values in an array

I'm trying to cumulate the sums of values in an excel column of 4 values dimension (4,1).

So, I constructed the code below. For the first row in a column on the side Result, it is supposed to hold the same value as in the original Array.
But then, once it is greater than the first row, it is supposed to get the previous element of result (i-1) and add to it the current column element (i).

VBA is telling me that the subscript is out of range :/ and I cant figure out why... so I dont even know if my code does what I want.

Please Login or Register  to view this content.

Hi,

like this?

Please Login or Register  to view this content.

Regards

Hmmm, it does work, but it posts the value from the last element in rColumn in all 4 rows of result.. :S

try one of those:

Please Login or Register  to view this content.

It works, thanks for the help!

Though, I have the question, wouldn't this be possible with the code I wrote originally too? :/ I just can't see where I went wrong with that one..