VBA Code for Montecarlo Simulation
 

I would like to set up a spreadsheet intended for Montecarlo simulations to
iterate a number of times (say 1000), while saving the frequency of each
outcome on a separate table or graph. I know that pressing F9 recalculates
the spreadsheet, generating a new outcome each time. What would the VBA code
look like for this routine?

VBA Code for Montecarlo Simulation
 

Rafage-
Save a lot of hassle by using the free add-in PopTools, which
incidentally includes a superb rng (current state of the art for MS sims).

Dave Braden

Rafaga wrote:
I would like to set up a spreadsheet intended for Montecarlo simulations to
iterate a number of times (say 1000), while saving the frequency of each
outcome on a separate table or graph. I know that pressing F9 recalculates
the spreadsheet, generating a new outcome each time. What would the VBA code
look like for this routine?



--
Please keep response(s) solely within this thread.

VBA Code for Montecarlo Simulation
 

Thank you, David!. I will try it.

Best regards,

Rafaga.

=====================================
"David J. Braden" wrote in message
...
Rafage-
Save a lot of hassle by using the free add-in PopTools, which incidentally
includes a superb rng (current state of the art for MS sims).

Dave Braden

Rafaga wrote:
I would like to set up a spreadsheet intended for Montecarlo simulations
to iterate a number of times (say 1000), while saving the frequency of
each outcome on a separate table or graph. I know that pressing F9
recalculates the spreadsheet, generating a new outcome each time. What
would the VBA code look like for this routine?

--
Please keep response(s) solely within this thread.