Hi!

When I run this macro, I want it to change the color of the text in the header into .Color = -10659502.
I've tried several things to code it correctly, but as a beginner in VBA programming, I can't figure out how to code this.

This is my code, and it works , I only need to find a way to also change the color of the text ..
Sub Macro2()
    Sheets("Offerte").PageSetup.LeftHeader = "&""ITC Avant Garde Gothic Medium""&24Offerte " + Sheets("Werkbrief").Cells(1, 2)
End Sub
I hope someone can help me out!