View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_39_] Bill[_39_] is offline
external usenet poster
 
Posts: 11
Default 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 ***