Adding running total macro

Originally Posted by djbomaha

Hi agzil,

Here is some code that adds a formula in the cells in Column B to keep a running total, starting with Range B3. If you insert it outside of your "For Coin - Next Coin" loop, it should work.

' Add Running total to Column B
For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
   Range("B" & i).Formula = "= A" & i & " + B" & (i - 1)
Next i

Hope that helps,

Dan

Dan! Thank you so much! I'm very new to all this and I've been stuck on this problem for quite some time now..So basically what you did is set the formula for the range. Can you please explain line three in more detail?