That does it - Thanks for the prompt response.

I'm sure back in 95/97 there was some way to insert a reference to a cell in
the dialog. I don't remember dropping in to VBA to do it, but then it was a
long time ago.

Cheers


"Bob Phillips" wrote:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.LeftHeader = ActiveSheet.Range("D1").Value
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian __ Lowe" <Brian __ wrote in message
...
I need to show the content of a specific cell in the custom page header
when
I print my worksheet.

I'm sure it can be done because I did it way back in Excel 95 or 97, but I
can't find the right search term to locate it in the help, and the wizard
guidance only helps me put file/sheet/date/page data values in there.

So, how do I get the content of cell $D$1 to appear as part of the page
header?

Not saying there wasn't, but I am not aware of it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian __ Lowe" wrote in message
...
That does it - Thanks for the prompt response.

I'm sure back in 95/97 there was some way to insert a reference to a cell
in
the dialog. I don't remember dropping in to VBA to do it, but then it was
a
long time ago.

Cheers


"Bob Phillips" wrote:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.LeftHeader = ActiveSheet.Range("D1").Value
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian __ Lowe" <Brian __ wrote in
message
...
I need to show the content of a specific cell in the custom page
header
when
I print my worksheet.

I'm sure it can be done because I did it way back in Excel 95 or 97,
but I
can't find the right search term to locate it in the help, and the
wizard
guidance only helps me put file/sheet/date/page data values in there.

So, how do I get the content of cell $D$1 to appear as part of the
page
header?