From the XL 4 Macro Reference:

> Scale is a number representing the percentage to increase or decrease the
> size of the sheet. All scaling retains the aspect ratio of the original.
> - To specify a percentage of reduction or enlargement, set scale to
> the percentage.
> - For worksheets and macros, you can specify the number of pages
> that the printout should be scaled to fit. Set scale to a two-item
> horizontal array, with the first item equal to the width and the
> second item equal to the height. If no constraint is necessary in
> one direction, you can set the corresponding value to #N/A.
> - Scale can also be a logical value. To fit the print area on a
> single page, set scale to TRUE.

Note that in my macro, I've used "Zoom" instead of "Scale"



In article <dsiil1tad4qi4mepguhdfplpntm70mqkge@4ax.com>,
PeteCresswell <x@y.z.Invalid> wrote:

> On Fri, 21 Oct 2005 10:02:18 -0600, in microsoft.public.excel you
> wrote:
>
> > http://www.mcgimpsey.com/excel/udfs/pagesetup.html
>
> Thanks. That's just the ticket - runs in a flash.
>
> Now, not to turn into a tarbaby on you.... but it looks like the parms
> in PAGE.SETUP are positional, but I can't find anything on it.
>
> I need to add FitToPagesWide and FitToPagesTall....
>
> Gonna start just trying blind, but in the event that I can't stumble
> into it, do you have any idea where to go for docs on that string?