Extract worksheet name from a chart formula

[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!

 

[Andy Pope]

Hi,

Try John Walkenbach's class object,
http://spreadsheetpage.com/index.php/tip/a_class_module_to_manipulate_a_chart_series/

Cheers
Andy