Page Setup

[ioncila]

Hi

This is a hard question, I think:

I know how to code normal page setup but

Is there a way to automatically setup a page in VBA over a readability parameter and considering the range size:

- setup papersize A4 or A3 or A2
- setup portrait or landscape
- setup one or more pages

Thanks

[royUK]

You would probably need to use the PageBreaks

[ioncila]

Thanks for the reply.

However, pagebreak may be not the solution because, if I do that, I'm setting up a specific area.

Depending on the sheet, print area can be short or big. What I wish to know if is possible to determine (in an automatic mode) print area based on those parameters and set up page by papersize, viewtype and number of pages in a readability view.

For example, if print area has 10 cols and 20 rows, setup would be A4, portrait, 1 page. If print area has 150 cols, 1000 rows, setup woul be A2, landscape, 5 pages.

Does is it mean reasonable?