| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting Pivot Table Grand Totals
I would like to interrogate the value of a grand totals field to determine
it's formatting What is the property or object that I must use to get the value and not the name of the field? The following returns the name of the field (The same as the name in parenthesis) MsgBox PvTbl.PivotFields("Sum of Num of Occ").Value Thanks for your help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - copy specified Grand Totals | Excel Worksheet Functions | |||
| Grand totals Pivot table | Excel Discussion (Misc queries) | |||
| Pivot table row grand totals | Excel Discussion (Misc queries) | |||
| Need help with grand totals in pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Totals | Excel Worksheet Functions | |||
Threaded Mode
