cell a1 has formula =int(rand()*15)
If I use use code to make b1 = a1 VBA seems to use its own random integer.

Can anyone enlighten me and if possible have vba use the display value in a1.

thx