VBA for Pasting with Specific Color

[ShawnExcel]

Good Morning!

I am looking for a bit of VBA code I can put into a Microsoft Word macro that I'm using to paste Excel cells. Essentially, I am using Excel as a questionnaire (survey, if you will) and then the results are populating into a word document. I am having trouble since there are 400+ links between the documents and it's slowed down to an absolute standstill. I am reducing the number of links by copying 5 cells at the same time, and pasting it into word using a quick macro I made:

Sub Macro1()
'
' Macro1 Macro
'
'
    Selection.PasteSpecial Link:=True, DataType:=wdPasteText, Placement:= _
        wdInLine, DisplayAsIcon:=False
End Sub

The issue is that it somehow shows up in white font, instead of black font. Originally it is 12pt Times New Roman Bold Black font. When it's pasting everything is correct except the font color. Can I insert anything into this macro so it pastes in black? Anyone have tips/tricks for formatting links between excel and word?

Thank you!

 

[ShawnExcel]

I think part of the reason that it keeps freezing/crashing is because it automatically pastes these links to automatically update. Can I have them automatically paste as Locked and/or Manual updates?