Page Break Coding

Hi Anyone.
I have an excel sheet with data of 5 tables with same header like:
header-----------
r1..
r2..
.
.
.
r10

header----------
r1..
r2..
.
.
r7

header------
r1
r2
.
.
r15

--How can I code to give a page break after 2 table record set. I mean I want to put 2 table record in one page.
I tried but its having my page break plus also the system page break that comes after certain number of lines.

Thanks

Have you tried View > PageBreakPreview > and then just dragging the
pagebreaks to wherever you want them?

Vaya con Dios,
Chuck, CABGx3



"jesmin" wrote:

>
> Hi Anyone.
> I have an excel sheet with data of 5 tables with same header like:
> header-----------
> r1..
> r2..
> .
> .
> .
> r10
>
> header----------
> r1..
> r2..
> .
> .
> r7
>
> header------
> r1
> r2
> .
> .
> r15
>
> --How can I code to give a page break after 2 table record set. I mean
> I want to put 2 table record in one page.
> I tried but its having my page break plus also the system page break
> that comes after certain number of lines.
>
> Thanks
>
>
> --
> jesmin
> ------------------------------------------------------------------------
> jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
> View this thread: http://www.excelforum.com/showthread...hreadid=495153
>
>