+ Reply to Thread
Results 1 to 2 of 2

Set page breaks across multiple sheets macro

  1. #1
    Registered User
    Join Date
    09-14-2018
    Location
    USA
    MS-Off Ver
    Office 2016
    Posts
    23

    Set page breaks across multiple sheets macro

    I have a file that processes commissions in Excel. There is a macro button that I click to create a new tab for each salesperson and displays and summarizes all their customers. This works fine. The problem is, the macro doesn't change page breaks across the newly created tabs. Some of the tabs have page breaks from Column A to Column E, others are from Column A to Column D. How can I write a second macro to set the print area across all sheets from Column A to Column E except for 4 tabs named Sheet1, Sheet2, Data, Summary? It is ok if the salesperson's commission report is longer than one page, I just need to make sure all the columns fit and the report is centered on the page. This is the code that I've tried and it sets the print area from Column A to Column E but it doesn't move the page break that is between Column D and Column E.

    Please Login or Register  to view this content.
    Last edited by xceler8or; 10-11-2018 at 08:59 AM.

  2. #2
    Registered User
    Join Date
    10-11-2018
    Location
    Gurgaon
    MS-Off Ver
    XP
    Posts
    10

    Re: Set page breaks across multiple sheets macro

    Thanks for explaining this . I appreciate your work.

+ 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. Setting page breaks on multiple sheets at once?
    By taylorsm in forum Excel General
    Replies: 3
    Last Post: 08-09-2016, 03:57 PM
  2. Finding page breaks in excel sheets & inserting empty row
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2015, 09:54 PM
  3. [SOLVED] [Solved] Split into multiple sheets by page breaks, preserving formatting
    By tecsbrain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-07-2014, 03:24 PM
  4. Replies: 4
    Last Post: 12-04-2013, 05:32 AM
  5. Multiple page breaks error
    By jfrey in forum Excel General
    Replies: 0
    Last Post: 09-20-2011, 05:31 PM
  6. Replies: 1
    Last Post: 03-15-2009, 06:08 PM
  7. Batch Inserting Row Sheets in between page breaks
    By TeraFractal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2008, 06:40 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