>Hi all
>
>I have got a Pivot table created through OLE automation from a range of data and I now need to create a chart based on the pivot data range. I would appreciate if you advise how can I determine the pivot data range programatically as the data range is one of the necessary parameters to the ChartWizard method.
>
>Thanks & Best Regards
PivotTables("pivotName") would give you the range.
Cetin