Shane,

I am somewhat new at this, can you provide a little more explantion? I tried
to enter the string below into the page setup, custom header field with no
success. I'm sure I am doing something wrong. Can you simplfy? When I get the
the header set-up box what should I enter? Thanks for your help it is really
appreceated.

"Shane Devenshire" wrote:

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.