I'm trying to write a macro that will check all of the series in a
given chart and make sure that they are pulling from the same sheet
name. Is there a way to step through each series value, extract the
sheet name it's pulling from (I could feed this into an array), and
then compare those values (I could use the filter function on the new
array). I just can't seem to find a way to extract each series value
in order to pull them into an array. Any help would be appreciated.
I guess I'm just not real familiar with series/seriescollection
syntax.

Thanks,
Jamie

See John Walkenbach's page on Chart Series:

http://j-walk.com/ss/excel/tips/tip83.htm
A Class Module to Manipulate a Chart SERIES

--
Regards,
Tom Ogilvy



Jamie wrote in message
om...
I'm trying to write a macro that will check all of the series in a
given chart and make sure that they are pulling from the same sheet
name. Is there a way to step through each series value, extract the
sheet name it's pulling from (I could feed this into an array), and
then compare those values (I could use the filter function on the new
array). I just can't seem to find a way to extract each series value
in order to pull them into an array. Any help would be appreciated.
I guess I'm just not real familiar with series/seriescollection
syntax.

Thanks,
Jamie