Custom Header

S

scrabtree

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?
 
N

NickHK

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

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hard return in textbox for header text 4
Userform textbox string to header causes unwanted double spacing 4
Custom Worksheet Header 1
Header properties in code 2
Updated header information from cell 5
VB coding assistance for Header/Footer 1
change event 2
Custom Header 1

Top