Set the calc mode to Manual
(Click Tools Options Calculation tab)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DAVIDT" wrote in message
...
Using RAND or RANDBETWEEN to randomly select a number from a specific
range
allows a new random number to be calculated when any other cell is filled
and tabbed. I only want the random number to change when F9 is used. How
can
this be done?