G Guest Dec 28, 2005 #1 I'm wondering if there is a way to display the contents of a cell in the header or footer of a spreadsheet.
I'm wondering if there is a way to display the contents of a cell in the header or footer of a spreadsheet.
C Chip Pearson Dec 28, 2005 #2 Not automatically. You need to use VBA to do it. In the ThisWorkbook code module, use code like the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Range("A1").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Not automatically. You need to use VBA to do it. In the ThisWorkbook code module, use code like the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Range("A1").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
