jtblackburn
Board Regular
- Joined
- Aug 14, 2007
- Messages
- 63
I have a workbook with Pivot Tables on each worksheet. On the "Contact Plan" worksheet, I would like to run a macro I recorded after each time the Pivot Table is refreshed. How can I do this?
I tried putting the macro code into the Worksheet_PivotTableUpdate event for that sheet and it works. However any time I try to refresh a different worksheet pivot table, I get the following error:
Rin-time error '1004':
Select method of Range class failed
How can I fix this?
I tried putting the macro code into the Worksheet_PivotTableUpdate event for that sheet and it works. However any time I try to refresh a different worksheet pivot table, I get the following error:
Rin-time error '1004':
Select method of Range class failed
How can I fix this?