Copy text formatting (not cell formatting) to vba script

[Bravo33]

Hi Currently using the following vba to copy from one workbook to another, however, this copies with no text formatting.

Some of the text is grey, red or blue and I need to copy that over. But not copying the cell Fill format.

Had a search with no luck. Help appreciated.

Sub Copy_Abstract_Grid()
'
' Copy_Abstract_Grid Macro
'

'
    Sheets("ABSTRACT GRID").Select
    Cells.Select
    Selection.Copy
    Sheets("ABSTRACT GRID FILE TRANSFER").Select
    Cells.Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Cells.Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
End Sub

 

[Kenneth Hobson]

How is the text formatted? Font by character(s), conditional format, macro, custom numeric, etc.

 

[Bravo33]

The only formatting is a manual change of color and font.
Columns D and E contain hyperlinks.

 

[Bravo33]

Still struggling with a solution. If anyone is able to assist it would be greatly appreciated