VBA Code for Montecarlo Simulation

  • Thread starter Thread starter Rafaga
  • Start date Start date
R

Rafaga

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?
 
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
 
Thank you, David!. I will try it.

Best regards,

Rafaga.

=====================================
 
Back
Top