How do i select 2 seperated ranges on one spread-sheet, set print area, and
have the 2 ranges print on one PDF sheet, one range on top of the other?

A reply in terms of excel macros would be ideal.

Thank you.