Setting Different Print Titles For Different Pages

**reachharry** · 01-28-2015, 07:01 AM

Hi Folks,

I did a lot of Google research to find the answer for my question, but could not find it.

My requirement is fairly simple. Is it possible to have two different print titles on the same worksheet?

I want to pick one row title if the number of pages to be printed is less than or equal to 2. If the pages exceeds 2, then for the first two pages I want to have one print title and for the remaining ones i want to have a different print title.

It would be of great help if you could help me in solving this.

Thanks

**Richard Buttrey** · 01-28-2015, 07:34 AM

Hi,

Set a cell variable that can determine how many pages you're printing, perhaps use the number of rows in the print area, and use that variable in a formula that chooses the print title. I presume by print title you are simply meaning a normal row and not the 'rows to repeat' un the page set up area.

**reachharry** · 01-28-2015, 07:41 AM

Hi Richard,

Thanks for the prompt reply.

That's a good idea.

I can use the line Activesheet.HPageBreaks.Count to find how many pages are going to be printed.

What I mentioned through the word "Print Title" actually the rows to repeat.

If my coding line gives the answer as 0 or 1, then I would need the Rows (1:13) should be at the rows to repeat.

If my coding line gives answer as 2 or more than that, then in that case I want to have Rows(1:13) to be repeated for first two pages and from the third page onwards it should take Rows(1:6) as the rows to repeat.