View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NHVP Treasurer
 
Posts: n/a
Default can I use a cell's contents as part of a custom header?

Excel 2003.
I'd like to use the contents of a cell as the custom header...too often I
forget to change the custom header to be the updated text. Specifically, I
need to list the _next_ month & current year in my page header. (ie, this is
February 06, so I'd like the header to read "March 06", without having to
open the custom head dialog box each time)