Range for series - VBA

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi
Is there an easy way to get the range a particular series is looking at?
Thanks in advance.

Tired this...

Dim nextSeriesRange As Excel.range
Dim nextSeries As Excel.Series
Dim chartSeriesCollection As Excel.SeriesCollection

Set chartSeriesCollection = chart.SeriesCollection 'Is a valid cart
object!
For Each nextSeries In chartSeriesCollection
Set nextSeriesRange = Excel.range(nextSeries.Values) '<-Get an error
here
' blah......
Next
 
Back
Top