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.
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.