Re: Extract auto-calc % scale so as to construct a macro to add controlled Page Breaks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Aug 10, 11:44 pm, RJQMAN <rjq...@xxxxxxxxx> wrote:
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.

I found the answer on a microsoft help site! Just setting the number
of pages option to 'False' allows the automatic function to still work
and maintain the page breaks. I do not mean to waste anyone's time,
and hopefully this information will help someone else.
.

Relevant Pages

  • Re: Help for least square
    ... > My problem is how to using 'LEAST SQUARE METHOD' for fitting or extract or combine, or select automatically through to resulting matrix. ... I'm going to take a guess: do you want to fit four straight ... > I don't like use this method, caused the last column the value is zero, dan first column its value lower around twice from second column. ... If all your measurements were 0, why do you think the actual ...
    (comp.soft-sys.matlab)
  • Re: Green transport
    ... which is only currently possible if you extract the ... maximum amount of energy out of a very very fit person indeed, ...
    (uk.misc)
  • Re: Who is the @#$%^&* that invented the zipper?
    ... Slackware is way too large to fit on my ESDI drive, ... Right now I am going to try a different version of PKUNZIP to extract ... Prev by Date: ...
    (comp.sys.ibm.ps2.hardware)
  • Re: How do I extract coefficients from fit
    ... for which I used the function fit(). ... General model Gauss2: ... Coefficients: ... How do I extract the variables, a1, b1 etc. for use further along in my ...
    (comp.soft-sys.matlab)
  • Re: Nonlinear regression
    ... I am trying to fit my data points with a function that looks ... Is there something I can use, to extract those parameters ... you could use the function lsqcurvefit from the Optimization Toolbox, ... or, if you don't have it, try to use fminsearch for the function ...
    (comp.soft-sys.matlab)