View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TxcPhtm TxcPhtm is offline
external usenet poster
 
Posts: 6
Default In Excel How Do I Random a Number but Not when it recalculates?

I am trying to make a Macro that will select a few cells and random number
between 1-100 (I have done this). But when I use =RANDBETWEEN(1,100) whenever
I change a number in my cells it randoms. I was wondering whether there was a
=random that doesnt do after every recalculate. Or a Macro term.