+ Reply to Thread
Results 1 to 2 of 2

Add page break before cell which contains specific text

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    16

    Add page break before cell which contains specific text

    I tried many different ways and have not been able to be successful. I am not sure what is the best approach either. My goal is to add a page break before each cell which contains "MBU:" It just so happens that MBU: is the first 4 characters, but I would rather know how to do it if the cell contains the characters anywhere in the cell. I tried a find and replace as well. This is my current itteration of the attempt. I would appreciate any help. Thank you.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by saniamarco; 08-03-2018 at 08:00 AM. Reason: adding file

  2. #2
    Registered User
    Join Date
    08-16-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Add page break before cell which contains specific text

    In case this helps anyone else I figured it out. I had to reset the breaks first. Here's what worked:

    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] Find row number above specific row, then insert page break
    By mvparker79 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2017, 01:40 PM
  2. Page Break Preview with specific word
    By melleniam in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-25-2014, 06:00 AM
  3. 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
  4. Replies: 1
    Last Post: 01-28-2013, 02:14 AM
  5. Replies: 0
    Last Post: 03-22-2009, 10:52 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. [SOLVED] 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

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