I have built a worksheet to run simulations using the rand() function, and I would like a macro to run the simulation xx times (F9 to recacluate), each time copying the result value on another tab of the workbook to document the xx trials.

Seems simple, but I've had no luck recording a macro and modifying the code to automate. Any help would be appreciated.