Random Numbers

[benji2004]

Hi Anyone,

What I need is a Macro/Formula that generates 1 random number and doe
not change when a drop down list is changed...Could anyone help

 

[Frank Kabel]

Hi
you may use the following macro which insert a random number in the
active cell

Sub rnd_insert()
activecell.Value=rnd
end sub