Chris,

You can print out more than one row in the headers.

So you set the print titles and the print area with the following:

With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$3"
.PrintTitleColumns = ""
.PrintArea = "$4:$16"
End With

and then print it out and then you set the print titles and the print area
again with the following:

With ActiveSheet.PageSetup
.PrintTitleRows = "$30:$32"
.PrintTitleColumns = ""
.PrintArea = "$33:$166"
End With

and then print it out.
--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"ChrisO" wrote:

Hello,

I have a worksheet with two sections of data, both of which may spread
across multiple pages in printed output.

Each section has a different set of column headers, which I want to use as
the title row for each printed page.

I am familiar with using the PrintTitleRows property but this only allows me
to have one title row(s), which is fine for the first section but not for the
second one.

Can anyone tell me if there is a way (in a macro) to set up separate title
rows for different sections of a single worksheet.

Many thanks.

Chris