print different row titles in one sheet w/ many pages

[Carman Law]

Would like to ask
1. How to print a row title in say pages 1-10 and another row title in pages
11-20 within one sheet?
2. Print row titles in pages 1-10 and then no row titles in pages 11-20
within one sheet?

Thanks

 

[David McRitchie]

Hi Carman,
You have to print pages 1-10 separately for page 11-20 using
the two different headers. 1-10 separately for the other sheet
and 11-20 with no headers.

You can do that within a macro.
Headings for Columns, and Page Numbering
http://www.mvps.org/dmcritchie/excel/headcols.htm