you could use paste special- formulas/values and number formats or
other options to do the copy.
--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile:
http://www.excelforum.com/member.php...o&userid=34322
View this thread:
http://www.excelforum.com/showthread...hreadid=544293