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.