Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with headers in pagesetup
I want to add a header as below. However, I want to replace the word "Test"
with a variable. How do I do that and still retain the formatting? With ActiveSheet.PageSetup .CenterHeader = "&""Arial,Bold""&14Test" End With Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with headers in pagesetup
Hi Okie
With ActiveSheet.PageSetup ..CenterHeader = "&""Arial,Bold""&14" & _ ActiveSheet.Range("M1") End With -- ----- XL2003 Regards William "OkieViking" wrote in message ... I want to add a header as below. However, I want to replace the word "Test" with a variable. How do I do that and still retain the formatting? With ActiveSheet.PageSetup .CenterHeader = "&""Arial,Bold""&14Test" End With Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Working with headers in pagesetup
Dim myvar
Dim hdr myvar = ??? 'replace the word "Test" hdr = "14"& myvar With ActiveSheet.PageSetup .CenterHeader = "&""Arial,Bold""&hdr" End With Should get you close to what you want Mike F "OkieViking" wrote in message ... I want to add a header as below. However, I want to replace the word "Test" with a variable. How do I do that and still retain the formatting? With ActiveSheet.PageSetup .CenterHeader = "&""Arial,Bold""&14Test" End With Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PageSetup Macro | Excel Worksheet Functions | |||
Working with Headers and Footers | Excel Discussion (Misc queries) | |||
PageSetup | Excel Discussion (Misc queries) | |||
PageSetup | Excel Programming | |||
VBA 'PageSetup' performance | Excel Programming |