Well, that's what the RAND() function does...right?
So, here's my thought:
Why not put the RAND() function someplace where it will do no harm, then
copy/paste_values the latest random value where you need it?

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Christy" wrote:

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 !!