Hi

I have a VBA macro to do some iterative calculations. Currently the values are read and written in a spreadsheet, in a deterministic fashion.
I'd like to be able to run this model in a probabilistic mode, i.e. some of the input parameters can vary, and the output values be produced as ranges/distributions.

I've used Oracle Crystal Ball for spreadsheet calculations, but not in a macro.

What is the best way of having input values read from a distribution defined using Crystal Ball, running the iterative calculation through a macro, and writing the results (e.g. avrages and maximums) in a spreadsheet.

Thanks.