Get the name of current pivot field
 

Hi,

Is it possible to get the name of the pivot field into a variable. i
am creating a pivot table through VBA code, i let users select the
fields which needs to be put into the DATA for Sum.

Ex.
In DATA, i have "Sum of ABC", so when i want to see "Sum of 123", then
i need to remove "Sum of ABC" from DATA field.

Please let me know how this can be achieved.

Thank you for the help.

Navin