Re: $$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

Thanks, I discovered the error, but ended up using your's macros, thank you very much all. On 7 June 2013 15:27, Bé Trần Văn wrote: > You try this Code, used for Version. > > Code: > Sub PivotTable_Change() > Dim PTCache As PivotCache > Dim PT As PivotTable > Application.ScreenUpdating = False >

$$Excel-Macros$$ Help Pivot table gives error when adding to "addDataFiled"

Hi guys, I don't know why but I have this recorded macro, that always gives me an error when is putting the field "QTY" - Quantity in the Values field? Can you help me? Private Sub splitf() Application.ScreenUpdating = False Range("A1").Select Range(Selection, Selection.End(xlToRight