Excel Chart SourceData Question??

[MoGolgo]

Hi,

Does anybody know how to extract the SourceData range from an Excel chart in Excel 2000. I understand you can set the range by using :-

ActiveChart.SetSourceData Source:=Sheets("Sheet1&quot.Range("A33&quot


I need to be able to check that the range ("A33&quotwas used in a chart using VBA code.

Thanks
Mo

 

[RobBroekhuis]

Use the Chart.Series.Formula property (play with it, you'll see).
Rob