View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jostlund jostlund is offline
external usenet poster
 
Posts: 18
Default Headers and Macros

I have a number of working papers that all have a 3 line header. The first
line is the company name, 2nd line is the GL account name and number, the 3rd
line is the "As at" date (January 31, 2007, Februay 28, 2007, etc.) It
changes every month. I thought I could record a macro to update the date
each month but it replaces the entire header. Is there a way to do this??