Automatically print all page contents in pivot table.
 

Hi All,

Can anyone help me with writing a macro whe
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.

--
David P