Hi all,

I have an Excel app. which generates a number of tables.
The table widths are constant but the heights vary, depending on the data
source.

Objective - To print as many full tables that will fit onto a page without
splitting a table between two pages, using a variety of computers and
printers.

I know how to set a page break - although I am rather puzzled by the
presence of both PageBreak and HPageBreak operators, which seem to be
unrelated!

What I not able to do is to determine where the first break will occur if
generated automatically - this I think wil enable the other breaks to be
calculated.

Note:- I've tried running the file on two computers using the same printer.
Although the PageSetUp details are exactly the same, the printed output is
different. i.e the automatic breaks are not the same.

Any advice will be gratefully accepted.

Regards,
Don

Hi,

Addendum
One computer has Excel 97 while the other has Excel 2003 - I don't know if
this makes any difference.

"Don Lloyd" wrote in message
...
Hi all,

I have an Excel app. which generates a number of tables.
The table widths are constant but the heights vary, depending on the data
source.

Objective - To print as many full tables that will fit onto a page without
splitting a table between two pages, using a variety of computers and
printers.

I know how to set a page break - although I am rather puzzled by the
presence of both PageBreak and HPageBreak operators, which seem to be
unrelated!

What I not able to do is to determine where the first break will occur if
generated automatically - this I think wil enable the other breaks to be
calculated.

Note:- I've tried running the file on two computers using the same
printer. Although the PageSetUp details are exactly the same, the printed
output is different. i.e the automatic breaks are not the same.

Any advice will be gratefully accepted.

Regards,
Don