scrabtree,
You need to change the "," to "&", as in:
ActiveSheet.PageSetup.CenterHeader ="&""Arial,Bold""&14"&Range("D7").Value

NickHK

"scrabtree" wrote in message
...
ActiveSheet.PageSetup.CenterHeader ="&""Arial,Bold""&14",
Range("D7").Value

I can get the custom header to equal a cell value, I just
can't get it to format the way I want?