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.
Bookmarks