Code to select a range and set it as the print range onto one page

**rlsublime** · 12-10-2011, 02:22 PM

Hello:

I am trying to set a certain range (A1:M36) as the print range and I am trying to get it to print on one page. I currently have a report that is auto generated but A1:M6 prints on 6 pages. I am trying to get it to print on one page. Is there a way to add code to set A1:M6 to be printed on one page?

Thanks

**Mordred** · 12-10-2011, 02:25 PM

You want to combine 6 pages into 1? Aren't your worried about readability?

**rlsublime** · 12-10-2011, 02:42 PM

5 of the 6 pages are blank. Thanks for the help

**Mordred** · 12-10-2011, 03:22 PM

I think you are going to need to upload a mock workbook with mock data in it (nothing sensitive or personal). It should have both before and after representations of your requirements.

**john55** · 12-10-2011, 03:37 PM

hi,
I use something similar, try to see if it helps...

Please Login or Register  to view this content.

Code to select a range and set it as the print range onto one page

LinkBack

Thread Tools

Rate This Thread

Display

Code to select a range and set it as the print range onto one page

Re: Code to select a range and set it as the print range onto one page

Re: Code to select a range and set it as the print range onto one page

Re: Code to select a range and set it as the print range onto one page

Re: Code to select a range and set it as the print range onto one page

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions