View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RC RC is offline
external usenet poster
 
Posts: 39
Default Save RAND select number

Hello,

I want to use RAND BETWEEN to pick a random number from a list - and then
save it so it will not recalcutate. My intention is to use it as a way to
randomly select a winner of a drawing.

I tried to password protect the work sheet, but that didn't work. And, I'm
not sure why. Is there a way to randomly select a number, row or cell and
NOT have it recalculate?