If you use VBA, you can.
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("sheet1")
.PageSetup.RightHeader = "This is what's in A1: " & .Range("A1").Text
.PageSetup.LeftHeader = Format(Date, "mmmm dd, yyyy")
End With
End Sub
This kind of code goes behind the ThisWorkbook module.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
mykmag wrote:
Is it possibe to insert a cell referance/link of your own make, in the
heading/footer of a page/sheet in Excel 2003?
--
Dave Peterson