View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I customise my headers so they are all different?

I don't understand the pattern you want to use, but Ron de Bruin has a macro
that changes the print titles for page 1 and page 2-???.

http://www.rondebruin.nl/print.htm#not

I bet it could be modified to do what you want...

atomdunjey wrote:

I am trying to make a diary and would like the header on the even pages to
say Term 1 Week 1 then Term 1 Week 2 etc but because there are also odd
pages it can only put page numbers in so it becomes Week 2 then Week 4 etc


--

Dave Peterson