Hi all,
I see that this topic has been covered before but I think that I am asking a different question to those already answered.
I have recorded a macro to edit the header/print title of a worksheet. I have set the LeftHeader to equal some text and to changes it's colour to blue. I have also set the CenterHeader to reference Cell ("C1") in the spreadsheet. I would like to combine these two so I can reference a cell AND also change the text colour automatically.
I have tried som simple combinations but with no luck. Any advice?
Bookmarks