Macro to set print area, select pivot table portion

[srikanth_s]

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 code I could use to do the following:

1. Select the row labels in the pivot table (IE, not the part that says "Data Items Here" or something like that -- I'm not using that portion of the pivot table)

2. Change that selection to include four rows above (where I have custom headings)

3. Set the print area

Any help you could provide would be fantastic. Thanks so much in advance!

 

[PCL]

If you can do it manually a macro will certainly do it.
Can you send a screen shot of the Pivot Table and inform about the area to print and the same for the fours rows above.

 

[srikanth_s]

PCL,

Thanks for your reply.

Here's a screenshot:

The highlighted portion is what I'd want to set as print area. Merci d'avance!

 

[srikanth_s]

Just to clarify, what I'd like to understand is not how to set the print area to the range shown in the screenshot -- instead I want the code to set the print area to the specified sections of the pivottable (which vary depending on user input).

I need some help with understanding how to select what I think is called the row ranges in this pivot table.