Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Simon Reid" wrote in message
...
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!