Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.PageSetup.Zoom
I'm trying to set the pagesetup to Fit 1 page wide in code. The number of
pages will vary from 1 to 50, so i have no way to predict that. So, i do the following: With ActiveSheet.PageSetup .Zoom = True .FitToPagesWide = 1 .FitToPagesTall = 99 End With I receive an error at the .Zoom = True When i look at the page setup, i see the 1 and 99, but it does not show me the "Fit to:" option selected. Thank you, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.PageSetup.Zoom
Oops...The .Zoom should be set to False
Thank you. wrote in message ... I'm trying to set the pagesetup to Fit 1 page wide in code. The number of pages will vary from 1 to 50, so i have no way to predict that. So, i do the following: With ActiveSheet.PageSetup .Zoom = True .FitToPagesWide = 1 .FitToPagesTall = 99 End With I receive an error at the .Zoom = True When i look at the page setup, i see the 1 and 99, but it does not show me the "Fit to:" option selected. Thank you, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveSheet.PageSetup.PrintArea variable ? | Excel Programming | |||
pagesetup.zoom problem !!! | Excel Programming | |||
Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub | Excel Programming | |||
read ZOOM after setting FitToPagesWide in pagesetup | Excel Programming | |||
read ZOOM after setting FitToPagesWide in pagesetup | Excel Programming |