Put this one-line macro in WorkBook code:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.CenterHeader = Range("A1").Value
End Sub

The value in A1 will appear in the Center Header
--
Gary's Student


"RobM" wrote:

I know I can link cell to cell, but for this report, I want to take some
linked header information out of the worksheet and put it in the header.