i have a problem

[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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[raja_x]

thx for that, will keep in mind