| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Header using cell data
I'm trying to create a header that will pull in data from a mergerd cells
which are typically located in mergers cells C4-G4, C5-G5, etc. I want the header to appear as:- " Project" & Ative sheet cel C4-G4 " Address" & Active sheet cell C5-G5..... I've established from previous posts that the code should go in the workbook before print event but not really got any further.... Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Header using cell data
This will do it ...
Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftHeader = _ "Project: " & ActiveSheet.Range("C4") & Chr(10) & _ "Address: " & ActiveSheet.Range("C5") End Sub -- Cheers Nigel "Wayne" wrote in message ... I'm trying to create a header that will pull in data from a mergerd cells which are typically located in mergers cells C4-G4, C5-G5, etc. I want the header to appear as:- " Project" & Ative sheet cel C4-G4 " Address" & Active sheet cell C5-G5..... I've established from previous posts that the code should go in the workbook before print event but not really got any further.... Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return header cell of last column with data | Excel Discussion (Misc queries) | |||
| How to have cell data display in header | Excel Discussion (Misc queries) | |||
| How to incorporate cell data in a worksheet header | Excel Worksheet Functions | |||
| Excel: want header cell sizes to differ from the other sheet cell. | Excel Discussion (Misc queries) | |||
| attn: Tom Ogilvy cell data in header | Excel Programming | |||
Linear Mode
