Best way of copying text to Word from Excel
 

Hello, I'm having some trouble copying cells from Excel to Word by macro.

Let's say I got two cells in excel, A1 and A3 which I need to copy to Word.

A1 is Arial, regular.
A3 is Verdana, bold.

I need to transfer these to Word and preserve the formatting but paste them
as text. I have tried pastespecial wdpastetext. This is otherwise fine but
does not copy the formatting. Other options I have tried copy the cells as
"true cells" to Word (plain pastespecial, pastespecial wdpasteRTF,
pastespecial wdpasteHTML) - I need to transfer it as normal text with
formatting.

Any suggestions how to do it?

Thanks guys,
TT