Formatting pasted range/table from Excel into Word - VBA

[Anna007]

I have a bookmark in my word document and then I have this range in Excel (Amortization Table)
I am doing the following to copy and paste it into the word doc where the book-mark is:

range("AmortizationTable").copy
mydoc.Bookmarks("MyBookMark").range.pastespecial

Now, it's pasted as a table that it was in excel. But does word treat this as a table?? I need to do an AutoFit (to fit in the windowP) after pasted it - but via VBA Code!
there is an autofit property but not sure how to use it in this case. I tried but it was pasting it in excel intead!
I need it pasted into the word doc.

Thanx,
Anita

 

[aradha]

Hi Anna,
Why don't you do a autofit in excel and then copy the word into word?

Radha