<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
i am looking for a vba code that when i run in a workbook with so many pivot tables, in a new sheet it would create a report like below<br />
<br />
Pivot Table Name &nbsp; like this &nbsp;Pivottable1<br />
Pivot Table data source SheetName &nbsp;like Sheet1 etc<br />
Pivot table Data source range address like A1:D400<br />
<br />
in addition if it also can put the pivot table data source background color<br />
<br />
thanks,.
</div>
</div>


Hi

i am looking for a vba code that when i run in a workbook with so many pivot tables, in a new sheet it would create a report like below

Pivot Table Name   like this  Pivottable1
Pivot Table data source SheetName  like Sheet1 etc
Pivot table Data source range address like A1:D400

in addition if it also can put the pivot table data source background color

thanks,.

vba help

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.