excel formula and VBA not friends

[marshall_massive]

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

[gyclone]

Please Login or Register  to view this content.

[marshall_massive]

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

Can someone please help!!!

[marshall_massive]

Had to change formula calculation to manual. Thx clone

[gyclone]

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