View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Adam Kroger
 
Posts: n/a
Default Freezing the cell (with Random formula)

SEE! I'm not the only one!

:)

I have been trying to figure that one out for weeks.



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