Thread: Including Spreadsheet Date in a header
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
david mcritchie david mcritchie is offline
external usenet poster
  
Posts: 691
Default Including Spreadsheet Date in a header
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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


Reply With QuoteReply With Quote