View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Various different page headers for one sheet

With code it is possible

See
http://www.rondebruin.nl/print.htm#Header



--
Regards Ron de Bruin
http://www.rondebruin.nl


"sanjiyan_s11" wrote in message ...
Is it possible to set up different page headers for one sheet? I have page
breaks so that data belonging to different codes print on separate pages. I'd
now like to add the code and it's description to the header for each page. I
expect I need to set up a macro but am not sure of the best way to do it.

I'd rather not chop up the sheet as the workbook is already large, with
multiple sheets.