I wish to be able to store running totals in my Spread
sheet.

If I have values in A1:A10 for example, how would I add
the values to B1:B10 respectively.

Once they are added up, the Values from the formulas in
A1:A10 will be cleared by my Macro.

Basically, all I want is a formula to add A1:A10+B1:B10
then hold the values in B1:B10.

After the sheet has been filled in again, I would like to
repeat the process, keeping the B column as a running
total.
Pete