Hello Dreamz,

The code should be working as is. I have tried several variations of
the Copy and PasteSpecial to duplicate the problem, but I can't. I
created a UserForm with a checkbox, and placed the paste code into a
project module, and everything works. Which means there is something
else causing the problem. I look over your code again and see if I can
spot something.

Sincerely,
Leith Ross


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=480621