excel formula and VBA not friends

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

Please Login or Register  to view this content.

Thx for your reply gyclone, but did u actually test this code as it doesnt work for me.

Can someone please help!!!

Had to change formula calculation to manual. Thx clone

Ah, sorry about that. Mine is almost always set to manual.