View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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