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").Range("A3:D3")


I need to be able to check that the range ("A3:D3")was used in a chart using VBA code.