VBA copy to word - copy font colour

[chrisellis250]

Hi all,

I have the below code, which copies data from my spreadsheet into a specific word document. As shown within the code, it highlights some specific text based on the cell colour. How could I do similar to enable it to set the font colour, as the same font colour as the value in the cell? i.e. the font colour of C29 in respect of Subject Number 1 to 4:

Please Login or Register  to view this content.

Many thanks,

Chris

[:) Sixthsense :)]

.Value simply post the Value only.

Why don't you use the same interior color logic for font color?

Like the one which you did in your code

.Bookmarks("SubjectNumber1").Range.Shading.BackgroundPatternColor = ws.Range("C29").Interior.Color

[chrisellis250]

How would the code for that look? Unsure whether the 1st part would be shaded, then I imagine the second part would be .Font.Color?

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[chrisellis250]

Hi, this code does seemingly work - however it doesn't copy the correct colour...

[chrisellis250]

So, the font colour in C29 was pink, but when I copied it the font colour showed as yellow.