Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Current page method of pivot field failed | Excel Programming | |||
Changing a pivot table field items to current database | Excel Programming | |||
Setting pivot table field (current page) to a chosen value | Excel Programming |