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

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

Thanks for your reply.

How I can do this if I use Table?

Soniya,
If you want the table, then why not just copy from Excel and paste into Word
?
That way you get everything.

NickHK

"Soniya" wrote in message
oups.com...
Thanks for your reply.

How I can do this if I use Table?

No, I want cells to appear in the other way
in Exce it is A, C and D
and in word i want it to be in one column only