I get the error stating that I can't make this change (or copy a range to a destination) because it will affect Pivot Table.
Now there are two solutions I thought of:
• Deleting Pivot Tables entirely. But this is pointless as my report requires it.
• Referencing table in targetWb.Sheets(n).Range("A2"). How would you copy a range to a destination that is a listobject in position cell A2?
Essentially, I am trying to import workbook from range to a table that is connected to a PivotTable.
Please Login or Register to view this content.
Bookmarks