Forgive the earlier smart-alec post, as I said I have been searching fro the
answer to this one for awhile. I have found 1 way to "freeze" the rand()
thus far.

If you have a checkbox linked to cell A1
cell B1 =IF(A1=TRUE,rand(<whatever),"")

because a checkbox linked cell does not recalculate unless the checkbox is
triggered, the rand() will not recalculate. It only solves about half of my
issues wich is why I am still trying to find a way to freeze the cell by its
own formula, but maybe this will work for you.

"Christy" wrote in message
...
Everytime I copy the cell (wth rand() formula) and paste it to another
cell
(use paste special - value - ok), the value of the original cell changes.
How
can I freeze the value of the original cell? Thanks a lot !!