Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Suppressing Page Break

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Tip Top Builders, Inc.
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In Lotus, I had created a macro to print two dis-similar spreadsheets onto
    the same page, first over the second.

    How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?


  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Rich,

    Not sure if this is want you want

    http://www.mrexcel.com/board/viewtop...c=6087&forum=2

  3. #3
    New Member
    Join Date
    May 2002
    Location
    Tip Top Builders, Inc.
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Brian:
    Thanks for the info, but pasting two to one sheet does not work because the columns are dis-similar.
    I just need to print the first sheet and suppress the page feed to "hold the image still" while I print the second sheet.
    Kind of - access to printer controls.
    Rich

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Rich,

    Try the camera utility

  5. #5
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-09 15:51, RichSoz wrote:
    In Lotus, I had created a macro to print two dis-similar spreadsheets onto
    the same page, first over the second.

    How do I suppress the page break at the bottom of the first spreadsheet, so that I can do a similar thing in Excel?

    You could try the Repoprt Manager accessed via VIEW|Report_Manager and set up a report consisting of various sections. I am not sure if it will meet your needs regarding different sections on being the same page.

    And of course you can always hide the rows you do not want to print, and then print it as a continuous report.

    Regards!
    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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