Don't want to constantly update Random numbers
 

Hi, I have a worksheet with thousands of random numbers being generated. But
it takes a while for all the boxes/formulas to update every time I change a
single box in the worksheet. Can I somehow force it to NOT UPDATE these
random numbers every time? Besides, I'd prefer if the numbers would not
change, because then I have to adjust my plots every time they update. It
would be more convenient if all my random numbers just stayed the same from
now on. Can I do this?

Thanks,

ApeMan

Don't want to constantly update Random numbers
 

1. - simply translate ur formula to valus
or
2. - set calculation to manual then run:

Sub myCalc()
Range("A20:A40").Calculate ' change to what range u want
End Sub



"ApeMan" skrev:

Hi, I have a worksheet with thousands of random numbers being generated. But
it takes a while for all the boxes/formulas to update every time I change a
single box in the worksheet. Can I somehow force it to NOT UPDATE these
random numbers every time? Besides, I'd prefer if the numbers would not
change, because then I have to adjust my plots every time they update. It
would be more convenient if all my random numbers just stayed the same from
now on. Can I do this?

Thanks,

ApeMan

Don't want to constantly update Random numbers
 

Select and Copy the range
Then Use Edit | Paste Special - Values to convert formulas to values
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ApeMan" wrote in message
...
Hi, I have a worksheet with thousands of random numbers being generated.
But
it takes a while for all the boxes/formulas to update every time I change
a
single box in the worksheet. Can I somehow force it to NOT UPDATE these
random numbers every time? Besides, I'd prefer if the numbers would not
change, because then I have to adjust my plots every time they update. It
would be more convenient if all my random numbers just stayed the same
from
now on. Can I do this?

Thanks,

ApeMan