Including Spreadsheet Date in a header

[Steve]

Is there any (preferable easy) way to to automatically
include the contents of a specific cell in the custom
header information?

 

[David McRitchie]

Hi Steve,

Don't know about preferable, but the following should work

Activesheet.PageSetup.LeftHeader = Range("B2").value

More information on headers and footers in
http://www.mvps.org/dmcritchie/excel/pathname.htm