How to extract the address of a chart serie
 

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

How to extract the address of a chart serie
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Vinz" wrote in message
s.com...
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