I am trying to allow Excel to scale a document so that it occupies the
full width of a landscape page. Of course the automatic scaling
feature can do this. However, when that happens I want to be able to
control the Page Breaks. This has long been a problem for me. I am
wondering if there is a solution anyone knows. Or perhaps someone can
tell me how to extract the % scale that Excel automatically calculated
when set to the 'fit to page' option so that I can use that number and
manually plug it into a print macro. I know that if I set the print
to automatically adjust to fit the page, the reduction number is
displayed to me. I just do not know how to extract that number so
that I can use it, or if it is even possible.

Thanks for anyone's help.