selecting 2 ranges, 1 Worksheet, printing on 1 page PDF

N

need help please

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.
 
Top