View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Font format in Word

Soniya,
I'm no Word expert but how about
<PsuedoCode
Loop
'Copy range("A1")
YourRefToWord.Selection.PasteSpecial Link:=False, DataType:=wdPasteRTF,
Placement:=wdInLine, DisplayAsIcon:=False
'Add the 2 blank line
Do until all ranges complete
</PsuedoCode

Other methods you get the table with the formatting, which I assume you are
trying to avoid.

Nick

"Soniya" wrote in message
oups.com...
Hi All,

I am trying to copy Range A1, C1, D1 to Word Document

I have defined this as X
(like X= A1 & vbcrl & vbcrl & C1 & vbcrl & D1)

How I can apply the same font format in Word too?

In my A1, C1 and D1 often it may contain different font (different
language) based on criteria.

and also Right to left characters.

Thanks