Save to .pdf with custom page setup

Hi all, I have been struggling with a save to .pdf macro. I have a Macro in place where I can save my active sheet as a pdf. The sheet is 280 rows long and the .pdf output is spread over multiple pages due to it's length. This is also completely fine.

The range of the entire sheet is A1:H280. What I'm trying to achieve is to have the range A1:A80 to fit onto the first page of the .pdf, and the range A81:H280 can be spread out over the rest of the pages in the same pdf.

Im currently using:

Please Login or Register  to view this content.

This creates the pdf I need. The struggle is limiting/fitting the custom range A1:A80 on page 1. I have experimented with custom page breaks and PageSetup (Wide/Tall) but have not succeeded yet. The final document will (with all sheets/workdocument locked) be shared with other users.

Hope someone is able to shine a light on this issue - thank you!

I don't know of a way to treat some rows different than other rows for page layout formatting. I have two ideas:

1. Move rows 81-280 to another sheet. Then you can format the first sheet as "One page tall" and print both sheets to PDF at the same time.

2. Create a new sheet used just for printing purposes that has references back to rows 1-80. Set that sheet up as "One page tall" and then set the Print Selection for the original sheet to A81:H2380. Then print both sheets to PDF at the same time.

Please Login or Register  to view this content.

I can be more helpful if could provide your file.

Thank you for your thoughts! I have also already tried your suggestion in 1) by moving rows 81-280 to another sheet. What I struggled with in this case was how to print both sheets to PDF at the same time.

For the ' original' sheet with rows 1-80 I still need to use

Please Login or Register  to view this content.

and I haven't succeeded in expanding the range to the new sheet with the other rows.

What I should clarify is that the sheet with rows 1-80 is a sheet that users can duplicate. When they than save to PDF this newly duplicated sheet should go on page 1, but the same sheet with rows 81-280 should come after that. That's why I thought I had to keep using ' ActiveSheet' , but with that command I haven't been able to figure out how to print two sheets to PDF at the same time.