Re: Good chalenge on header/footer
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Fri, 14 Oct 2005 21:40:15 -0400
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" <leon22.1wx5eb_1129338305.4062@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:leon22.1wx5eb_1129338305.4062@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=11427
> View this thread: http://www.excelforum.com/showthread.php?threadid=476426
>
.
- Prev by Date: Re: possibly array formula for depletion
- Next by Date: Re: Print VBA code in Editor format colors
- Previous by thread: Re: Good chalenge on header/footer
- Next by thread: Re: Email body with a script and a table
- Index(es):
Relevant Pages
|
