Despite searching Google, I don't seem to be able to find the answer to my question/problem.

So, say a chart has a range something like:
Formula: copy to clipboard 
=xxx!$E$6:$E$188,xxx!$O$6:$Y$188
how would I return that range address?

Rider: there are several charts on several sheets so, how would I loop through the sheets and, within each sheet, return the chart title and range address for each chart.

I know that I can set the range using 
ActiveChart.SetSourceData range("=xxx!$E$7:$E$188,xxx!$O$7:$Y$188")
but I need to be able to establish what it currently is in order that I can adjust it.

Do I need to select the sheet and/or the chart (making it active) in order to test and set the range?

Thanks in advance

TMS