Creating pivot table to Existing worksheet
Here's all the relevant information:
a) I was able to successfully create a pivot table, in a newly created tab named "Sheet2". This pivot table is contained in A:E, was copied and the duplicate of that pivot table pasted into I:M. b) Next I attempted to generate a new pivot table, using a new data range, to the "Existing worksheet" at P:V. When running the VBC code for the new pivot table I get the error "Run Time 1004: Unable to get the Pivot Table Property of the Worksheet class" The broken VBA code is below: Quote:
Any help would be greatly appreciated!!! :) |
I wonder if the target worksheet must be actually named, vs the default Sheet1, Sheet2, Sheet3, etc etc
Quote:
|
All times are GMT +1. The time now is 05:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com