Paste selection from excel to word in specific paragraph

[batonring]

Code snippets are provided for those who want to automate this process, although they may need to be adapted for specific requirements. To paste the selection into the fifth paragraph of an existing Word document, you can modify the code to set the range to wdDoc.Paragraphs(5).Range before pasting the data. Make sure the Word document is open and accessible in your code.

If you paste the code below into word, it will be an error, so you need to change it to wdDoc.Paragraphs(5). Then paste this code only to match the table from excel to word.