see the example below: [vb] Sub PTTest() Dim SH As Worksheet ‘ the current worksheet from the colection of workbooks Dim PT As PivotTable ‘ the current pivot table from the current worksheet Dim PTC As Range ‘ the cell range of the current pivot table Dim Tmp AsString’ the buffer for concatenated cell values […]