Kirstie
Dragging & Dropping copies everything - text, formating, formulas etc
You would need to use Copy & PasteSpecial
--
mudraker
------------------------------------------------------------------------
mudraker's Profile:
http://www.excelforum.com/member.php...fo&userid=2473
View this thread:
http://www.excelforum.com/showthread...hreadid=540219