I have several lists of data in an excel spreadsheet, when I print them out I need the top line of each page to contain headings.

My problem is that printtitlerows will print the same header ON EVERY page, I want this header to change depending on what list is being printed at the time.

eg if printer is currently printing list B then the header for this page should be B...

printtitlerows only allows one heading to be printed, its VERY INFLEXIBLE..any help appreciated.

[email protected]