Values not visible in PDF after pasting Excel Range into Word table via VBA

Hi everyone!

I have a little sub like this as part of a larger Macro editing some Word-Templates:

Please Login or Register  to view this content.

My issue now is, that when I run this Macro, all text in the Word table is underlined with dots (see Screenshot below). However, formatting them with the normal Word underscoring does not change anything, so it is not really an underscore. I can only get them removed by copying the range in again by hand. Frustratingly, sometimes the pasting works just fine, but I have yet to find out, when and when not this is happening. Copying the values in the table after the Macro ran, pasting the values as textonly pastes nothing and pasting them as an Image creates a blank white image. Printing/saving the file as PDF makes the whole table appear empty.

Does anyone know of this issue or have any ideas, what to check for?
I've got it both to work and the issue to show up
- in debug mode and running through by itself
- with and without scrolling to the table so it is visible, when pasting
- using .PasteAndFormat wdPasteDefault instead of .Paste

I am really confused as to what the issue is and what could cause it.
Grateful for any help :)

For whatever reason the text is hidden, not underlined. So, you need to set the text as visible.

Please provide sample files: the Excel Workbook with the Range(s)/Table(s) and the Word Template with the bookmarks/Tables.

I still have no idea, why Excel pasted the text as hidden, but I'm happy enough with this solution.

Me neither.

But, you're welcome.



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.