Hi Everyone,
With the help of this forum I have a macro that converts every sheet in my workbook to PDF's, and then emails them to me. This has worked out great so far, with the exception of the sheets that require 2 or more pages due to their size. I'm trying to figure out how I can set up a custom print area, so that I can choose exactly which cells will show up on page 1, and which ones will show up on page 2 (and page 3, etc..). At the moment though, I have been unable to add any page breaks that would mark where page 2 should start, which causes the PDF to be a single page of unreadable data since there's so many cells included in one page. Can you all help me figure out how to set up these custom print areas? Here's the things I've tried so far:
- Inserting "Page Break" appears to do absolutely nothing no matter where I try to insert it.
- Dragging the page break in the "page break view" to my desired cutoff point for page 1. When I do this, the rest of the sheet is simply omitted from the PDF entirely.
I've attached some photos to explain -
Photo 1: Shows the entire sheet as a single page on the print area
Photo 2: The red line is where I want Page 2 to start
Photo 3: What happens when I try simply dragging the page break to where I want page 2 to start. It doesn't appear that a "page 2" is automatically added for me.
Bookmarks