I am not sure If I get your question.

B1 is = the value of A1?

Why would you need a macro change that? Just make sure you have
automatic calculation on.


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=547906