Good chalenge on header/footer
 

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

Good chalenge on header/footer
 

Hi Leon,

if you have 56 rows on a page

include the 9 rows want after row 56
then in rows to repeat use $57:$65

You will want to insert a page break before row 57
by selecting row 57 then insert page break

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"leon22" wrote in message
...

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

Good chalenge on header/footer
 

You have to hide the rows you don't want printed.


You will have to do 2 prints to get separate rows to repeat. 1 for the
first page. Hide the rows, do the rest.
--
Regards,
Tom Ogilvy


"leon22" wrote in
message ...

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