Print - Different Titles on a Worksheet
Posted by RitaFW on January 23, 2002 8:14 AM
I have an excel workbook that contains 14 worksheets. Each worksheet when printed is 6 pages. The first 4 rows on each page contains the titles for that page (each page is different). The data for one company I'm working on causes each worksheet to print 12 pages, which is not a problem. I'm wondering if there is a way for me to get the title rows for page one to print on page two, then the title rows for page three to print on page four, etc. It's thrown me for a loop since each page in the worksheet has a different title. It is not an option for me to break each of these pages on this worksheet into individual worksheets. Your thoughts and help will be greatly appreciated!
Posted by Tom Dickinson on January 23, 2002 10:20 AM
Set the area to be printed at the data only, not the headings. Then turn on your macro recorder and set up and print the first set of sheets. In the set up, put in the custom headings you want.
Now turn off the macro recorder and edit it (you can cut out pretty much all the lines of code except those you specifically changed, such as the center heading). Now copy the macro for the next set of sheets that need printing with a different heading, and edit the heading accordingly.
Hope this helps.
