Hello,

I am trying to do a simulation.
I have many random numbers (rand()) within my spreadsheet.

Right now, I keep hitting F9 until I get a certain set of numbers tha
meets some conditions I have.

I would like to know how to program a loop that essentially recalcs th
spreadsheet (just like hitting F9 over and over again) until a certai
cell value is less than a certain numerical value.

Additionally, I want many sets of random numbers that fit this criteri
(otherwise, I could hit F9 until I get one set and then just quit). S
I need something I can "run" repeatedly.

Any help would be vastly appreciated

--
Message posted from http://www.ExcelForum.com