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

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