Create VBA Code - Copy range from Excel to Word

[Omer_K]

Hey all
I have an Excel file in which there is a sheet called Data,
I would like a VBA Code that copy the range of cells from cell C3 to the last non-empty cell in column F and paste it into a new Word file,I would like columns C to F to be on one page in the Word file, but I don't have a problem with the rows spilling over into several Word pages.
It is also very important that the data is displayed in the middle,
the font size should be 16

thank you

 

[NdNoviceHlp]

Hi Omer_K. There's some code at this link that should help. Dave

[SOLVED] Fit large XL range to Word doc

Can't seem to Google up a working solution to paste and fit a large copied range from XL to a Word document. Here's my unsuccessful attempts. The WordApp is the active Word process. Any help welcomed. Dave 'WordApp.ActiveDocument.content.PasteSpecial Placement:=0 'wdInLine...

www.vbaexpress.com