Hi
your source has to have the same format as the target range (that is it
has to consist of merged cells also). This is one of the reasons not to
use 'merged' cells

--
Regards
Frank Kabel
Frankfurt, Germany

"Mark" schrieb im Newsbeitrag
...
I am trying to paste a text over merged cells. But Excel says that is
not legal.
Is there a way to copy over such cells?