page break positions ...

G

GUS

I have a sheet that contain text and many tables.
The broblem is that when i am trying to print the sheet some tables are
separated in two pages .
I cannot change the positions of the tables couse the rows that the table
contain is not regular. (sometimes the table contain 5 rows other 10 rows .
depens from the user if he want to fill all the rows or some of them.)

I have also a macro that hide all the blank rows when print preview the
sheet.(that's why the rows are not regular)
Any idea.?
p.s.The tables are designed with border lines
 
Top