"RANDOM FUNCTION"

[BERTRAND]

Is it possible to turn off the auto refresh for just one cell in my worksheet.
I use the random function to select from my selections. When a race goes inplay my selection column values go static and my RNG has a max value. But of course the generator keeps randomising at refresh intervals. How can I work it so that it continuously randomises until the race goes inplay?
I use an inplay timer for my trigger.
I am thinking mabe I could just copy the RNG output at trigger time -to another cell.

[BERTRAND]

It might be possible for me to put the rng into an IF statement and at the same time create a circular reference.
If I allow one iteration in the worksheet, would it function properely?