Excel Tables and Page Breaks

[Joek]

I have an issue on an Excel 2007 worksheet.

I have three Excel Tables (lists) on a sheet. Each table meeds to be
printed on a separate page.

I have inserted page breaks at the required sheet row. However when I
insert a row in a table - by right mouse click in a table and selecting
Insert, Table Row - a row is inserted in the table but the sheet page preaks
do not move accordingly i.e. as further roes are inserted the page break will
eventually be within the table.

Any advice would be greatly appreciated. I look forward to receiving
replies. Thanks in advance

JK

 

[Don Guillett]

You could use an identifier or a helper column with a number or text and
have a FINDNEXT in a before print macro set the page break at each one