G
Guest
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.
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.