D
Don Lloyd
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
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