| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I include a cell's value in a worksheet header?
I am running Office XP pro. I want to display the value of a cell in the
header when I print a worksheet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I include a cell's value in a worksheet header?
BillSea:
add this code to Thisworkbook Module 'ThisWorkbook Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftHeader = Range("A1") '.CenterHeader = "" '.RightHeader = "" End With End Sub -- 天行健，君*以自強不息 地勢坤，君*以厚德載物 http://www.vba.com.tw/plog/ "BillSea" wrote: I am running Office XP pro. I want to display the value of a cell in the header when I print a worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Include a specific Cell's Contents in a footer Excel 2003 | Excel Discussion (Misc queries) | |||
| Can I link a cell's contents to the header or footer in Excel? | Excel Discussion (Misc queries) | |||
| how to include a variable in the header and/or footer of a worksheet | Excel Discussion (Misc queries) | |||
| can I use a cell's contents as part of a custom header? | Excel Discussion (Misc queries) | |||
| How can I include the name of the tab in a header without typing . | Excel Worksheet Functions | |||
Hybrid Mode
