+ Reply to Thread
Results 1 to 1 of 1

Move Page Break 1 cell up if bullet-point is in on the page break.

  1. #1
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    101

    Move Page Break 1 cell up if bullet-point is in on the page break.

    Hello friends, hope all is well!

    The code in the attachment creates page breaks every 48 rows. It works well but needs an additional condition.

    You will notice that it breaks after certain bullet-points (e.g. 4 7 13).
    If it breaks under a bullet-point the page break should move and become above the bullet-point.

    Please help me with the additional need please.

    Thank you very much in advance.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. I can't move my page breaks in Page Break Preview
    By btaft in forum Excel General
    Replies: 7
    Last Post: 05-14-2014, 09:53 AM
  2. Find First match value and add page break, findnext value and add page break
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 12:58 PM
  3. Can't move a vertical page break
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2013, 10:39 PM
  4. Replies: 1
    Last Post: 01-28-2013, 02:14 AM
  5. Move page break to top of merged cell with VBA Excel 2010
    By marek12886 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2011, 03:21 PM
  6. need page break by asking the input file for page break to be done
    By saikumar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-10-2008, 07:33 AM
  7. using text wrap how can I type over the page break point
    By Mike Dewar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-22-2006, 01:10 AM
  8. adding a new page break to an existing page break
    By Edward Letendre in forum Excel General
    Replies: 1
    Last Post: 03-06-2005, 06:06 AM

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