Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Thanked 0 Times in 0 Posts

    Subtotal method, breaks= true, fit to 1 page wide. (xl '97 vba)

    With the settings mentioned in the subject line - page breaks do not work. However, if you change the Scaling option "Adjust to: " to what ever the setting was calculated to be - the page breaks WILL work. To solve my problem does anyone know how to calculate that "Adjust to:" property (Zoom)??

    I've tried setting the "Fit To" property (FitToPagesWide) with plenty of extra "Pages Tall" (FitToPagesTall) and then tried to read the Zoom property but all I get is "False"..

    Any ideas out there?

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Re: Subtotal method, breaks= true, fit to 1 page wide. (xl '97 vba)


    Since you have set the print to be on one page, Excel ignores page breaks. This is the way it works, and you have found out about it.

    Now to adjust the zoom, well this is AFAIK a gray area, the Zoom takes two types of arguments.
    When you use the FitToPagesWide or FitToPagesTall zoom is False and when you use it, its value is what you set it to be.

    There is a way to tell how many page breaks you have, thus the number of pages that would print and then you can set that to match the FitToPagesWide and FitToPagesTall and that would set the zoom.

    This method involves the old XLM language and you can find it on the MSKB. Sorry I don't remember the Q number.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts