I have a PT that is created from a Power Pivot table and I want to loop through each item in the 1 column of the PT.
I thought the following would workSet ptField = ptPivotTableList.PivotFields("Proper Name")but I am getting a 1004 error, Unable to get the PivotFields property of the PivotTable...