Page Setup Problems

  • Thread starter Thread starter elziko
  • Start date Start date
E

elziko

How would I set the pagesetup so that I fit to 1 page wide by N pages tall?
I've tried:

ActiveSheet.PageSetup.FitToPagesTall = False
ActiveSheet.PageSetup.FitToPagesWide = 1
ActiveSheet.PageSetup.Zoom = False

Thats half way there but Scaling is still Set to "Adjust To" when I open the
Page Setup dialog.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page Setup, Scaling 2
How to set PrintSetup? 8
Printing userform in landscape on one page only 2
PageSetup.Zoom=TRUE 3
page setup preferances 1
Problem with ExportAsFixedFormat in Excel 2007 11
Control Pagebreaks Programatically 3
PageSetup - Speeding up - Code snippet Requested 5

Back
Top