VBA - PivotSelection - Excel 97

B

Ben

Hi
I am trying to write a macro to generate a chart depending on what the user
has selected in a PivotTable. The PivotSelection property on the pivot
table seems to give inconsistent results depending on what is selected. It
returns a string, sometimes with the field name and square brackets,
sometimes not.. Sometimes there's a colon as a delimiter, instead of a
comma. Is there any documention anywhere on what this is actually doing?

Thanks
Ben
 
D

Debra Dalgleish

In VBA Help, look for 'PivotSelection Property'. Click on the link to
'standard PivotTable selection format' for information on the string
formatting.
 
Top