You would probably need to use the PageBreaks
You would probably need to use the PageBreaks
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks