Pivot Table Grouping
 

Hi All -

Hope someone can help with my question.

I am trying to build a pivot table using vba. My problem comes when
trying to manually group fields with text labels. I have two fields
named "Adjustments" and "Charges" which need to be grouped so I can get
a total.

My question: Does anyone know how to refer to these Labels in code
other than just using the cell reference? I have tried the PivotSelect
statement but that will not work when trying to select two fields.
Maybe if I can get the address returned and then use that as input for
the range.select?

Any insight would be appreciated.

Thanks.