Page Setup Property

[Kavy]

Hello all, I am specify that my worksheet, when it prints fits to 1 pages wide

ws.pagesetup.fittopageswide = 1

but for some reason it also fits to only one page long, I want it to fit to as many pages long as need be, anyone know anything about this?

 

[Atroxell]

try adding

        ws.pagesetup.FitToPagesWide = 1
        ws.pagesetup.FitToPagesTall = False

 

[Richard Schollar]

Hi

Try the following modification:

With ws.PageSetup
   .Zoom = False
   .FitToPagesTall = False
   .FitToPagesWide = 1
End With

 

[Kavy]

thanks all, didn't know i could set the FitToPagesTall to False!!

I new about the Zoom thing though, but why do you need to turn it off?
Not that important, just if anyone has a sec!

 

[Richard Schollar]

If Zoom is not set to False, then FitToPagesWide and FitToPagesTall settings are ignored - I found this out the hard way on a little project I created for someone at work. It is documented in the VBA Help in Excel, but it doesn't seem (to me at least) intuitive...

 

[Kavy]

thanks!