Hi,

Any idea on how to accomplish this? I guess it requires some tricky vb
code...

I have a report on which I have set rows 1 to 15 to repeat on each page
(using the "print title" option). However, I want rows 5 to 10 to
repeat only on 1st page.
i.e., Rows 1 to 4 contain Statutory Company info.
Rows 5 to 10 contain report specs
Rows 11 to 15 contain column headers.

So on the 1st page, I need all the rows.
On the remaining pages, I only want rows 1-4 and 11-15 to be
displayed.

I do not want to use the "Report Header" feature, as it is already used
for other information.

I tried to set-up "Print Title" with rows 1-4 and 11-15, but it does
not allow non contiguous range.

Any clue?

Thanks for any advice


--
leon22
------------------------------------------------------------------------
leon22's Profile: http://www.excelforum.com/member.php...o&userid=11427
View this thread: http://www.excelforum.com/showthread...hreadid=476426