without using your code i notice that in your IF THEN statement you
specify a range to copy and directly after specify a destination but no
selection or paste command.
Regards,
Simon
--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread:
http://www.excelforum.com/showthread...hreadid=572036