Programming to set print area and resize rows

Hi All,

I have a workbook containing a sheet that lists several possible line items in a price quote, and a pivot table containing those items selected by the user to be displayed (using checkboxes and a report filter).

I want my users to have to do as little as possible to go from selecting the rows to include, to printing to pdf. As part of this, I'm wondering if there is a way to do two things:

1. Automate the print area setting, and force to print to 1 page wide by 1 page tall
2. Set the height of blank rows appearing between items to 1

In the attached example, the code would not include the report filter row (row 2), resize rows 7, 9, 12, 14, 17, 19, 21, 24, 26, 28, 31, 33 to 1, and set the print area to A3:D33, on the basis of the fact that these rows include data.

I have 0 programming experience but would love to learn how to make this happen. Thanks in advance for anyone who can help with this ...