Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I use a cell content to auto-populate to a header in excel?
Hi,
You need to use code for this: Private Sub Workbook_BeforePrint() ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("A1") End sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire "DaveC" wrote: any help on this? I would like to use the contents of a cell to auto-populate the header. Thanks for any assit. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell content in custom header: How? | Excel Discussion (Misc queries) | |||
Cell Content as Header? | Excel Worksheet Functions | |||
cell content in header/footer? | Excel Discussion (Misc queries) | |||
view cell content in header | Excel Discussion (Misc queries) | |||
Excel find the content of cell using row and column header | Excel Worksheet Functions |