software

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

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

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

Thank you, David!. I will try it.

Best regards,

Rafaga.

=====================================
quot;David J. Bradenquot; gt; wrote in message
...
gt; Rafage-
gt; Save a lot of hassle by using the free add-in PopTools, which incidentally
gt; includes a superb rng (current state of the art for MS sims).
gt;
gt; Dave Braden
gt;
gt; Rafaga wrote:
gt;gt; I would like to set up a spreadsheet intended for Montecarlo simulations
gt;gt; to iterate a number of times (say 1000), while saving the frequency of
gt;gt; each outcome on a separate table or graph. I know that pressing F9
gt;gt; recalculates the spreadsheet, generating a new outcome each time. What
gt;gt; would the VBA code look like for this routine?
gt;
gt; --
gt; Please keep response(s) solely within this thread.