Share via

Excel VBA Copy and Paste to Word (Keep Formatting)

Anonymous
2024-02-08T18:44:22+00:00

Is there a way to use Excel VBA to copy a range of cells and paste them into a word document in paragraph format but also keep the formatting within the cells?

For example, if I have this data in Excel:

And I want it to paste into a Word Document to look like this:

I have created the below module in Excel VBA,

However, it results in the data being pasted as a table like this:

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-09T14:47:30+00:00

    Hello Evan Lei1,

    Thank you for writing to us here in the Microsoft Community.

    Based on your message, it sounds like you're experiencing issues with your Excel VBA. For this question is already out of my specialty and this is more complex and requires assistance upfront. I suggest posting your case here on Newest 'vba' Questions - Stack Overflow. Our experts can help you with your concerns. The VBA forums have a wealth of resources when it comes to VBA concerns.

    We will also leave the thread open for all volunteer moderators to join us and share their opinions/suggestions to help you address your concerns.

    I hope you find this information helpful.

    Regards,

    Michael Jr.

    Microsoft Moderator

    0 comments