Copy text with formatting VBA Excel
Posted on 2011-09-08
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
copies text just fine, but loses BOLD formatting.
I have tried
But they both error "cannot change merged cell"