That will delete all my links to the other sheets. I need a "clear all"
solution that will not elimanate my links to other sheets. I just want
it to a new sheet status so I can paste without getting either the "too
many different cell formats" error or the "the operation requires the
merged cells to be identically sized" error.


--
Mile029
------------------------------------------------------------------------
Mile029's Profile: http://www.excelforum.com/member.php...o&userid=21091
View this thread: http://www.excelforum.com/showthread...hreadid=386608