+ Reply to Thread
Results 1 to 3 of 3

Page Breaking when Less than 10 Rows left on Sheet

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Virginia, USA
    MS-Off Ver
    2007
    Posts
    82

    Page Breaking when Less than 10 Rows left on Sheet

    Hello,

    Is there a way for excel to know how many rows are left on a sheet when printing. Here is my problem, I have a random number of rows on any given report. I run a macro and I want to include a 2nd report at the bottom of my first list. Unfortunately, sometimes the start of the 2nd report happens right at a page break and it looks really bad. I'd rather have excel know how big my data set is and if it can squeeze on the same page do it, if not insert page break...

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,525

    Re: Page Breaking when Less than 10 Rows left on Sheet

    This will tell you the row below the top page break
    Please Login or Register  to view this content.
    This will give you the last row of the print area
    Please Login or Register  to view this content.
    Subtract one from the other and you'll have your rows left.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,525

    Re: Page Breaking when Less than 10 Rows left on Sheet

    Maybe try this
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] vba code to concatenate text at each end of page report from right to left page
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2017, 10:47 AM
  2. Replies: 8
    Last Post: 03-16-2016, 05:26 PM
  3. [SOLVED] Mail merge to pdf breaking contents page
    By jimminyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-31-2015, 06:18 AM
  4. Breaking up a sheet
    By thisandthat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 01:05 AM
  5. Replies: 2
    Last Post: 05-05-2006, 11:55 AM
  6. Weird auto page breaking that I can't get rid of...
    By creativeops in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 11:30 AM
  7. Replies: 1
    Last Post: 05-12-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1