Thanks Dave.

This is more like it, but it is incredibly tedious. Rather than type
parameters into dialogue box for every combination of parameter required, can
I use a formula to run the scenario, taking its parameters from elsewhere in
the calling sheet?


"Dave F" wrote:

I would look at the Scenario tool.

Tools--Scenarios...

Post back if you have questions.

Dave


--
Brevity is the soul of wit.


"Martin James Thornhill" wrote:

In Excel 2000, I have a complex calculation (in a worksheet) that takes 4
parameters and uses them in 4 different sub-calculations, involving
relative/conditional sub-sub-calculations. In effect, it's a model.

Having done this, I now want to pour a series of numbers into this model, to
see its effect on various combinations of parameters.

Rather than type each parameter in, copy-paste-value the result into a
summary table, how can I get Excel to run the model on call from a worksheet?

I am illiterate in VisualBasic, so anything that avoids macroes would be cool.