You should be able to use the same code in WkBookA and use 'I
Target.Address = "$A$1" Then' instead
--
Kre
-----------------------------------------------------------------------
Krem's Profile:
http://www.excelforum.com/member.php...fo&userid=2434
View this thread:
http://www.excelforum.com/showthread.php?threadid=37943