How to create a multipage PDF with an array of ranges?

[waimea]

I want to create a 3 page pdf with 3 different ranges in the same spreadsheet.

How can I do this?

Please Login or Register  to view this content.

I am trying to use an array of ranges but I cant' get it to work!

The 3 or more ranges I want to save to the same PDF file are

Please Login or Register  to view this content.

[jolivanes]

Hide the ranges you don't want printed.

[waimea]

Hi jolivanes,

thank you for your reply!

I get what you mean but I am trying to print 3 ranges or more to the same PDF and I would like to keep the design of the spreadsheet intact?

[jolivanes]

Range("B85:AA145") includes Range("B145")
In the next Range (Range("B145:200AA", I assume that should be AA200) you have it again.
Do you want that Row (B145:AA145) printed twice or is this a misprint?
Could this not be one Range as in Range("B85:AA200")?
What does the hiding of rows do to the design?

[waimea]

Silly me, it seems like it was as easy as adding the additional ranges within the range.

Please Login or Register  to view this content.

[waimea]

Thank you for your reply and your help, you are correct that it was a misprint!

I got it to work like I was trying to!

[jolivanes]

Good to hear and thanks for letting us know that you have it under control
Good luck

BTW, for people with a similar or the same problem that are searching this site for a solution, would you show your code?
That would be a possible great help to them.
Thanks