+ Reply to Thread
Results 1 to 3 of 3

Macro - Page Break Needs to Vary Depending on Merged Cells

  1. #1
    Registered User
    Join Date
    02-19-2009
    Location
    Wichita, KS
    MS-Off Ver
    Excel 2003
    Posts
    4

    Macro - Page Break Needs to Vary Depending on Merged Cells

    I'm not really great at describing my problem, so I'm attaching a copy of the calendar so you can see what I'm talking about. I'm working with a macro that formats a calendar. The calendars are sometimes too big for one page so I need a page break. I have figured out the vertical page break, but I'm having issues with my horizontal page breaks. The problem is that for any given calendar, each day can have merged cells for meetings that are longer than 30 minutes and depending on the days in the calendar, one cell will be merged and the next will not. I need to find a way in the macro to set the page break so that it will not split the merged cell. I don't know if this is possible without prompting the user to do it. I'm very confused by this.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Macro - Page Break Needs to Vary Depending on Merged Cells

    Hi,

    Quite difficult to help you out ... since you are not sharing with us the macro which needs fixing ...
    How have you solved the test of the merged cells ... so far ...

    HTH
    Last edited by JeanRage; 12-12-2009 at 04:19 AM.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Macro - Page Break Needs to Vary Depending on Merged Cells

    I would recommend avoiding the use of Merged cells
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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