Thanks June,

I appreciate your help! Your example worked great! Is there a way t
have the code paste a value in sheet two rather than reference th
cell?

Thank

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=46955