MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Random Numbers

Posted by Eric on November 05, 2001 5:19 AM

I am using the RANDBETWEEN command to produce random
numbers. My question is:

Is there a command that I can type into a cell to
lock in a random number once it is produced, so it
won't keep making new numbers everytime I enter
something in another cell?


Posted by Tom Urtis on November 05, 2001 5:28 AM

One option, you can copy the range, then Paste Special Values over that same range to make those random numbers static. If as you say you'd like to type a command to achieve this, you can write a macro to do this and assign that macro to a shortcut key.

Tom Urtis