Page Setup, Scaling
In The Excel page, if you go to File Page Setup, in the Page tab, there's a
heading for Scaling. That has: Adjust to: % normal size, and Fit to: pages(s)
wide by tall.
Is there a way for me to mimic the Adjust to: % normal size property in VBA.
I need to set that to 95% so that all the data on my page appears one page
wide. I've already set the page orientation to Landscape, and edited the
Right/Left Margins.
I tried using the activeSheet.PageSetup.FitToPagesWide = 1 line, but it
doesn't seem to cut the page to one page wide.
Any help would be greatly appreciated, this is the last step for me on this
macro.
|