VBA - PivotSelection - Excel 97

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
In VBA Help, look for 'PivotSelection Property'. Click on the link to
'standard PivotTable selection format' for information on the string
formatting.
 
Back
Top