page break at empty row

[gus]

I have a sheet with text and tables, and some empty rows between them.
In order not to brake the data (tables to two pages vertical) i thought that
i can redefine page breaks with vba, to the nearest empty row in default
pagebreak.
Is this possible?

For example if the default page breaks ends at row 35 and this row is in the
middle of a table , then remove pagebrake to the previus empty row which
could be row 29 or 28 or 25 etc.

 

[Tom Ogilvy]

there is no built in capability to do this.

 

[Cole]

Try to count how many rows in one page, then if cell <> empty at the last
row, find empty row above and apply page break, not sure if is possible but
just a suggestion.