Automatically print all page contents in pivot table.

D

David P

Hi All,

Can anyone help me with writing a macro where:
From a Defined Range (e.g. Sheet1! B9-B20), for each cell value, I would
like a pivot table page on another worksheet to change and then print the
pivot table report. In other words, I would like to automatically print the
pivot table report for each of the pivot table's page contents.
 
Top