Finding Source of Chart Data
 

Hello,
I would like to be able to, from a chart, find the worksheet containing
the data used to make the chart. Is there a way to do this? I can get
the formula that contains the name of the worksheet, but I don't know if
that is consistent across versions of Excel. Plus I guess I can find
the location of "," and then "!" and the name would be stuff in between.
Would that work with all versions of excel? Or is there a better way?

Thanks,

Bill



*** Sent via Developersdex http://www.developersdex.com ***