Paste Cell Contents into Custom Header

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
 
D

Don Guillett

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet
.PageSetup.CenterFooter = .Range("b12").Text
End With
End Sub
 
B

BCS

Was hoping there was a way to insert some code int he actual Custom Header
setup but this will work too.

Thanks,

Barry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top