Extract worksheet name from a chart formula

  • Thread starter Thread starter Simon Reid
  • Start date Start date
S

Simon Reid

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!
 
Back
Top