Try doing Edit, Paste Special and paste only the values in. This should
preserve any conditional formats that were there.


--
mdchachi
------------------------------------------------------------------------
mdchachi's Profile: http://www.excelforum.com/member.php...o&userid=33953
View this thread: http://www.excelforum.com/showthread...hreadid=536313