Store GoalSeek Iterative Attempts

[John Vieren]

Hi All,

Trying to capture the number of iterations and data used when running goal seek.
I tried setting max iterations to 1 and the using a for loop as illustrated in my code below.
it seems GoalSeek does not use 1 iteration as specified, any help is much appreciated.
Regards and thanks John

Please Login or Register  to view this content.

[Kaper]

Unfortunately MaxIterations is related to circular reference, not to GoalSeek.
I don't think you can do a Goal seek step by step.
You can mimmic GoalSeek by using Solver. You have to activate it (in file->options->add ins->manage->excel add inns->Solver) and then add a reference to int in VBA editor (Tools->references->solver - see screenshot)

Then you can use a value after each iteration.

Look in the sample file attached. Write something different than 1 (and not zero :-)) in D7 and run macro 3 shall make solver to do some steps).

This cell will be changed to get it's inversed value in D16 equal 1. And iterations will be listed below D16.

Adopt similar approach to your file (As you have not attached it' I've not tried to do some calculations far right in the spreadsheet).

Please Login or Register  to view this content.

[John Vieren]

Thank you for your assistance, much appreciated.