Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel saving as web page and scaling the print out to fit one page | Excel Discussion (Misc queries) | |||
Page Scaling | Excel Discussion (Misc queries) | |||
Page breaks and scaling | Excel Discussion (Misc queries) | |||
Problem Scaling to 1 Page Wide | Excel Discussion (Misc queries) | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) |