Paste Cell Contents into Custom Header

  • Thread starter Thread starter RoadRunner News
  • Start date Start date
R

RoadRunner News

I'm setting up a Custom Header under File...Page Setup and I want to be able
to include the contents of a cell in the Header. While the cell address
stays the same for every worksheet, the value within the cell will change.
Is this possible?

Thanks,

Barry
 
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.CenterFooter = .Range("b12").Text
End With
End Sub
 
Was hoping there was a way to insert some code int he actual Custom Header
setup but this will work too.

Thanks,

Barry
 
Back
Top