Hi,

I need to copy certain columns from a pivot table that changes size each week. I'm using the following code:

pt.PivotFields("Region_Name").PivotItems("England").DataRange.Copy
Workbooks(Dashboard).Sheets("Data Import").Range("AR2").PasteSpecial xlPasteValues
pt.PivotFields("Region_Name").PivotItems("Wales").DataRange.Copy
Workbooks(Dashboard).Sheets("Data Import").Range("AS2").PasteSpecial xlPasteValues
pt.PivotFields("Region_Name").PivotItems("Grand Total").DataRange.Copy
Workbooks(Dashboard).Sheets("Data Import").Range("AQ2").PasteSpecial xlPasteValues

The first two copies work fine - I can select a particular region with no problem. However, I get errors when I try to select the column that is labelled "Grand Total".

I've been searching for a solution, but not been able to find anything. Any help would be much appreciated.
Thanks