ExcelBanter - Page Break Coding

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