Random Number

[antony moseley]

Hi,

I have used various random generators advised on here, see below, but everytime i add some other data in a differnet cell it changes the random number - is there a way to make sure it doesnt change once it has created the random number?

Thanks

Antony
code]=INT(RAND()*5000) + 1[/code]

[martindwilson]

pehaps
http://www.fontstuff.com/vba/vbatut05.htm
will help