You're going about it the right way, extract the sheet name from the series
formula. You could show us your parsing routine in case it might be
simplified.

Regards,
Peter T


"Dan Thompson" wrote in message
...
Here is my problem:
I am using ActiveChart.SeriesCollection(1).Formula to return string that
contains the location of the data for that series [ie.. =SERIES("NY
Jet",Table!$A$2750:$A$6500,Table!$C$2750:$C$5856,1 )]

Then I am using a string parsing function I made to chop out the name of
the
worksheet to which that SeriesCollection came from. This seems like more
work
than it should be just to return the worksheet(name) that a particular
SeriesCollection in a chart belongs too.

There has to be an easier way ??
Any thoughts ??

Dan Thompson