+ Reply to Thread
Results 1 to 2 of 2

Want to remove blank page when splitting Word document

  1. #1
    Registered User
    Join Date
    06-06-2018
    Location
    United States
    MS-Off Ver
    2013
    Posts
    1

    Want to remove blank page when splitting Word document

    Good morning,

    I have a macro, copied from another person I found by googling, that helps to split a Word document by a certain number of pages. My issue is that it adds an additional blank page at the end of each split document. I don't know enough about the VBA coding language to know how to fix this. Can anyone shed some light? Here is the code below:

    Please Login or Register  to view this content.
    Thank you in advance!
    Clare
    Last edited by MCHolladay; 06-06-2018 at 10:50 AM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Want to remove blank page when splitting Word document

    You could try

    Please Login or Register  to view this content.
    I haven't tested this but the idea is that you avoid copying the page break (which causes the new page) by going back one character. You might need to go forward one character after copying to avoid having a blank page at the start of each sub-document.
    Martin

+ 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] macro showing error ( macro not found ) while trying to execute macro every 1 minute
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2018, 07:58 PM
  2. [SOLVED] Define variable in macro than calling that macro inside another macro
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-21-2015, 10:58 AM
  3. Using a macro on workbook1 to create a button in wb2 and assigning macro "wb2!macro"
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2014, 11:39 AM
  4. [SOLVED] Macro to show Which macro didnt work in a nested macro
    By akhileshgs in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2013, 03:21 AM
  5. Perform macro "on open" specific file- store macro in Personal Macro Workbook?
    By thompssc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 12:38 PM
  6. lookup macro, solver macro, realtime macro
    By xelhelp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2011, 06:14 PM
  7. Cannot find macro error when running a macro from a macro in a diffrent workbook.
    By Acrobatic82 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 09:22 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1