Put two chosen ranges on two different pages of one PDF document

Dear All,

Below you can find the code that I've written out in order to get a PDF copy of a chosen range from my excel worksheet. Could anyone tell me how they would adjust the code so that instead of having one single page with the two ranges, I could have 1 range on the first page of a PDF and the second range on the second page of that same PDF. (i.e. the PDF would have 2 pages with one range on each page.)
The execution is made via a command button (Button13_Click)
The two ranges would go from range1(A1:K77) and range2(A78:K196)

Please Login or Register  to view this content.

Thank you for your help!

Hey Jaslake,

Thanks for replying. Ideally I would want to do it through VBA coding, is there really no other way of doing it through coding?

Thanks again.

Hey Jaslake,

In the code written above, where would you include the VBA Coding to create the Page Break?

I'm struggling to see where it would ideally be placed

Thanks

something like this, no?

ActiveSheet.HPageBreaks.Add Before:=Range("A77")