<div>
Try doing Activesheet.Paste rather than PasteSpecial.<br />
<br />
Thanks<br />
Rob H
</div>


Try doing Activesheet.Paste rather than PasteSpecial.

Thanks
Rob H

<div>
A closer look at the sheets (created by someone else) revealed the source and destination were differrent sizes.... That caused the cannot change merged cell error. I went with your second suggestion and unmerged destination and used this code <br />
impSheet.Range(&quot;C23:K28&quot;).<wbr />Copy mySheet.Range(&quot;D25:L30&quot;)<br />
Works great!
</div>


A closer look at the sheets (created by someone else) revealed the source and destination were differrent sizes.... That caused the cannot change merged cell error. I went with your second suggestion and unmerged destination and used this code
impSheet.Range("C23:K28").Copy mySheet.Range("D25:L30")
Works great!

<div>
<div class="content wysiwyg-content">
I am importing info from one sheet to another.<br />
The FromSheet has a block of megered cells with text inside. The text is fomatted with some portions in <b>BOLD</b>.<br />
The NewSheet has a similar merged cell arrangement<br />
<br />
This Code:<br />
<br />
newSheet(destination)=from<wbr />Sheet(sour<wbr />ce) <br />
<br />
copies text just fine, but loses BOLD formatting.<br />
I have tried <br />
<br />
FromSheet(source).copy newSheet(destination)<br />
<br />
And<br />
<br />
FromSheet(source).copy <br />
newSheet(destination).Past<wbr />eSpecial<br />
<br />
But they both error &quot;cannot change merged cell&quot;<br />
<br />
Any ideas????<br />
<br />
<br />
&nbsp;<br />
<br />

</div>
</div>


I am importing info from one sheet to another.
The FromSheet has a block of megered cells with text inside. The text is fomatted with some portions in BOLD.
The NewSheet has a similar merged cell arrangement

This Code:

newSheet(destination)=fromSheet(source) 

copies text just fine, but loses BOLD formatting.
I have tried 

FromSheet(source).copy newSheet(destination)

And

FromSheet(source).copy 
newSheet(destination).PasteSpecial

But they both error "cannot change merged cell"

Any ideas????


 



Copy text with formatting VBA Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.