| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a link to a cell in a header in Excel?
I know I can link cell to cell, but for this report, I want to take some
linked header information out of the worksheet and put it in the header. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I insert a link to a cell in a header in Excel?
Put this one-line macro in WorkBook code:
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Range("A1").Value End Sub The value in A1 will appear in the Center Header -- Gary's Student "RobM" wrote: I know I can link cell to cell, but for this report, I want to take some linked header information out of the worksheet and put it in the header. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell References | Excel Discussion (Misc queries) | |||
| how do i set up a link between one excel cell from an access cell | Excel Discussion (Misc queries) | |||
| Excel: Format Control: 'cell link' reamins constant. How to copy | Excel Worksheet Functions | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
