View Single Post
  #1   Report Post  
DAVIDT
 
Posts: n/a
Default how do I prevent a RAND number from changing

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?