ExcelBanter - Custom Header

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Custom Header (https://www.excelbanter.com/excel-programming/306183-custom-header.html)

scrabtree[_2_]

Custom Header

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

Custom Header

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?

All times are GMT +1. The time now is 04:02 PM.