Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I place Range text into a header?
I am trying to have header and/or footer text update automatically when Range
text is changed. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I place Range text into a header?
Brad
Must be done programatically via VBA. Sub CellInHeader() With ActiveSheet .PageSetup.CenterHeader = .Range("A1").Value End With End Sub Or use a BeforePrint rountine. Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet .PageSetup.CenterHeader = .Range("A1").Value End With End Sub First macro goes into a General module. Second goes into the Thisworkbook module. Gord Dibben MS Excel MVP On Thu, 11 Jan 2007 13:16:00 -0800, Brad wrote: I am trying to have header and/or footer text update automatically when Range text is changed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Ranges using non-contiguous cells and dependent on a cell value | Excel Worksheet Functions | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
Using text for the range in AVERAGE function | Excel Worksheet Functions | |||
number range returning a text value | New Users to Excel | |||
Counting each time text appears in range??? | Excel Worksheet Functions |