Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom header | Setting up and Configuration of Excel | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Custom Header | Excel Discussion (Misc queries) |