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.
|