View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Reid[_2_] Simon Reid[_2_] is offline
external usenet poster
 
Posts: 6
Default Extract worksheet name from a chart formula

Hi,

I want to write a small program that will give me the name of all the
worksheets that are referenced by chart series.

I have tried to look at the chart series formula but am struggling to write
code that can account for all the variants, is there an easy way to do this,
or does someone have some sample code?

Thanks in advance!