How to extract the address of a chart serie

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 5
How can I get underlying range when Series Formula is longer than 255characters? 0
Copying Named Ranges in Chart Series 1
Placing an arrow on the series line in a line chart 5
Change Chart Series Formula 13
Excel Chart Series Values Property Size Limitation 9
hide legend for #N/A series 3
Need help to read Pie Chart Series Range 0

Top