Hi
I have a workbook that contains a number of Pivot Tables.
I want to create a macro that enables me to copy Pivot Table data into Word.
Given that the shape and size of the Pivot Table can vary I am struggling to find a way of automatically finding and selecting all the cells within the Pivot Table.
Any help on this much appreciated.
Thanks
Pete
I have a workbook that contains a number of Pivot Tables.
I want to create a macro that enables me to copy Pivot Table data into Word.
Given that the shape and size of the Pivot Table can vary I am struggling to find a way of automatically finding and selecting all the cells within the Pivot Table.
Any help on this much appreciated.
Thanks
Pete