ExcelBanter - Pivot Table Show Detail

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pivot Table Show Detail (https://www.excelbanter.com/excel-programming/440362-pivot-table-show-detail.html)

Les Gombart

Pivot Table Show Detail

I have a pivot table that i would like to use the ShowDetail property on... I
know how to code for this BUT I want the extract to always extract to a
specific range or sheet.

Is this possible and if so how?

ps Excel 2007

Thanks in advance.

All times are GMT +1. The time now is 02:49 AM.