Hi all,

this is a layout of my worksheet

Sheet Title
Part I title

Part II Title

Part III Title

Row number in Part I and Part III are fixed length, but row number in part
II is variable, so some new pages will need. On every new sheet there should
be a sheet Title and Part II title. These can all be done by code. But the
real problem is sometimes the Page Break Line will just go through the
inserted Sheet Title or Part II title that will make all decoration effort
pennyless. I am wondering how far can we go in the Excel print practice. If
you have some experience, let's share it?

Clara



--
thank you so much for your help