| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom header - utilize a cell for it's contents
How do I reference a cell in the customer header of a report so that if I
change the cell the report title also changes? -- M. Shipp |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom header - utilize a cell for it's contents
You cannot directly reference cell addresses in a header of footer, or insert
graphics for that matter. The following code snippet might get you pointed in the general direction. Dim strHeader As String Worksheets(1).Activate strHeader = Range("A1").Value If Len(strHeader) = 0 Then strHeader = "Put Optional Default Header Text Here" End If ActiveSheet.PageSetup.CenterHeader = strHeader -- Kevin Backmann "SHIPP" wrote: How do I reference a cell in the customer header of a report so that if I change the cell the report title also changes? -- M. Shipp |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a custom header that depends on cell contents? | Excel Discussion (Misc queries) | |||
| Custom Header - poss to link to contents of cell? | Excel Discussion (Misc queries) | |||
| can I use a cell's contents as part of a custom header? | Excel Discussion (Misc queries) | |||
| Put cell contents into header | Excel Programming | |||
| excel - insert cell contents in a custom header / footer | Excel Discussion (Misc queries) | |||
Linear Mode
