i have a problem

R

raja_x

Im using the randbetween function for my course work, but evertime i do
something, it keeps auto calculating, is there any way to turn this
off.
Thx
 
N

Norman Harker

Hi Raja_x

RANDBETWEEN is a volatile function that recalculates each time the
Worksheet recalculates.

Having generated a random number, it sounds like you want to fix it.

Select it (or the range containing random numbers)
Copy
Edit > Paste Special > Values
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top