simple VBA code help

[Iterator]

Hi,

I have the following code:

Please Login or Register  to view this content.

which adds up 1000 values and then divides by 1000 to give me an average.
However I need to save the value of a particular cell and add this to another cell AT EACH STAGE of the current 1000 calculations.

Can anyone show me how to do this please?

I'm thinking I need to create a loop within this loop ... but how?

[shg]

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.