Good Afternoon,

I can print titles on each page. I can create a dynamic print range. Darned if I can't do both at the same time. I'd prefer to keep VB out of it, but if it comes to that, it comes to that.

Background:
I have a form with 20 rows of entry fields per page. There is a page header. There are row headings which I would like repeated on each additional page without having to copy them for each page - that is, I want the file to display a seamless 120 rows of data entry with just one set of row headings, whereas if the user prints the form, it creates 6 pages of 20 rows, each page equipped with the header information and repeated row headings.

I have created a dynamic print range using the Offset function to encompass all entered data in increments of 20 (so that all sheets display a full grid, even if there is only one entry on that page). If it matters, here is my formula, placed in the Named Range "Print_Area":
=OFFSET(Sheet1!$A$2:$L$2,0,0,24+IF(ISERROR(CEILING(MATCH("*",Sheet1!$A$26:$A$125,-1)/20,1)*20),0,CEILING(MATCH("*",Sheet1!$A$26:$A$125,-1)/20,1)*20))
'Define the start and number of columns of the data - Create one whole page minimum - if there is no extra page data, return "0" - otherwise add 20 rows until print area encompasses all non-empty cells

Problem:
When I set "Print Titles", Excel redefines my dynamic Print Area to a static range of cells instead of my dynamic formula.

Solution:
Beats me!

Any ideas? Let me know if I did not adequately describe my situation. Thanks!