How to extract the address of a chart serie

[Vinz]

Hi there,

I would like to extract, within a vba procedure, the range a chart
serie comes from.

I know about the following code:

myvar = ActiveChart.SeriesCollection.Item(1).Formula

but this code return an absolute address and not a range.
Does someone has any idea?

Thanks a lot in advance,
Vincent

 

[Jon Peltier]

John Walkenbach has authored a class module which parses the chart series
formula and extracts this information:

http://www.j-walk.com/ss/excel/tips/tip83.htm

- Jon