Hi,
I've got problem with charts in vba.
I'd like to modifty data in the chart.
For example data of series1 are addressed "=CHF!A1:A5" and I'd like to
change it for "EUR!A1:A5". I've got to read first where the data of series1
are located.

I wanted to do it through:

dim strAddress as string
dim obChart as Chart

....

strAddress=obChart.SeriesCollection(1).Values

but it doesnt work because obChart.SeriesCollection(1).Values returns array.
How to read the address of series1?

Thanks for help
Mariusz