Read series values range of a chart

[matelot]

Is it possible to read the existing range defined in the values under source
data/series/Values? The reason is that I have a checkbox to hide/show the
value. Since I don't know the range, I want to read and put into a temp
variable so that when the user wants to show it again, I can add my temp
variable into the values box.
Is it doable?

Thanks

 

[Jon Peltier]

You can parse the series formula. John Walkenbach has a class module which
does this for you:

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

- Jon

 

[matelot]

Jon,
That's exactly what I need. Thanks so much for pointing me to the right
direction.

Mat