Custom Header

scrabtree · Aug 6, 2004

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?

NickHK · Aug 6, 2004

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

NickHK