Why not just paste in the value after you use the formula? I believe
all of the random functions (RAND, etc) are volatile.

HTH,
JP

On Feb 27, 4:56*pm, TxcPhtm wrote:
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.