Results 1 to 7 of 7

Thread: [RESOLVED] Don't scale when printing

  1. #1

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Resolved [RESOLVED] Don't scale when printing

    If I were to guess I'd say this isn't possible but what I'd like to be able to do is to print the first 5 columns of my worksheet and have them not scale bigger. In my code I've set the print area width to be the first 5 columns, and the length to be the last row. When I print it it scales the width of the first five columns up so that it fills the width of the page. Is there any way to stop that from happening?

  2. #2
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: Don't scale when printing


  3. #3

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: Don't scale when printing

    My zoom is 100%. The problem is that the total width of the 5 columns is less that a full page width so Excel scales up the width to fit the width of 1 page. I think that if I hide the columns to the right that contain data and then print more columns,

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

    Re: Don't scale when printing

    did you try set to pages tall?
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  5. #5

  6. #6
    PowerPoster jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,392

    Re: Don't scale when printing

    Or change the margins so that there is no room left to scale.

  7. #7

    Thread Starter
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,427

    Re: Don't scale when printing

    Thank you for the suggestion. It turns out that my workbook was corrupted and had several print areas that I couldn't remove or repair and I had to rebuild the workbook.

Posting Permissions

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



Click Here to Expand Forum to Full Width