How to extract the address of a chart serie

  • Thread starter Thread starter Vinz
  • Start date Start date
V

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
 
Back
Top