RAND fuction

[Jaunynas]

I have to make a macro which would make a table ( B4:K13 ) with each of its boxes containing a random number from 1 to 999 . These numbers can only change when macro is ran.
I have found this : =IF(ReCalc, RAND()*(High-Low)+Low,C3) but dunno how to make it work. Please help .

[Hercules1946]

I think Im right in saying that if your table is created as a VBA module (macro) then the macro will be the only way to change them.
Just make sure that you do all the calculations and update the table within the macro and recalc won't be able to change them.

[shg]

Please Login or Register  to view this content.

[Jaunynas]

Many thanks !