Calculating formulas after each iteration

[gromm]

Hi!

Is it possible to compute values in an Excel table after every iteration. The calculation in my MS Excel worksheet is set to manually calculate with an iteration of 50.

It generates a table that displays values of accumulated total after each iteration.

I'm having problems doing this because I could not find a procedure that would compute for the values after each iteration. I'm supposed to have an accumulated total at the end of the 50 iteration.

Thanks so much in advance for your help!


gromm

 

[johnwm]

This appears to be a pure Excel issue. You will probably do better in forum68 which is the Office forum

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[gromm]

yes, but I'm doing this calculation using VBA in MS Excel. I'm trying to convert the manual calculation with iteration in codes. I am hopeful that i can find an equivalent code for it.

 

[johnwm]

VBA forum = forum707

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller