Finding how many pages wide the print area covers

[Kalvas]

Is there a way to find out how many pages the document will print, so that I can adjust the zoom level so that it only fits one page wide. I have tried fixing the page width to 1 page but the automatic page breaks dont allow me to display all the data I require on one page.

I figure if i can get the number of pages wide to a variable i could use a simple while statement to adjust the zoom level so that it only prints 1 page wide.

Any help with this situation would be appreciated. Or even a point in the right direction.

 

[SMB Cooper]

Is there a way to find out how many pages the document will print....

If you will "Print Preview" you could see the information, example page 1 of 2 pages, etc.

 

[Kalvas]

I understand that, and thanks for the reply SMB. Maybe I wasn't being Clear.. what i need is to be able to put it into a variable in VBA so that i can adjust the Zoom level to ensure that all the data i wish displayed only fits on one page. when i tried to fix it to one page the automatic page breaks threw the entire thing into disarray.