Font format in Word
 

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

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

Font format in Word
 

Thanks for your reply.

How I can do this if I use Table?

Font format in Word
 

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?

Font format in Word
 

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