i have a problem

  • Thread starter Thread starter raja_x
  • Start date Start date
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
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top