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