SeriesCollection by name

[bradh_nz]

Is there a way in VBA to select the select SeriesCollection by name rather than by number ie

ActiveChart.SeriesCollection(1).Select as opposed to

ActiveChart.SeriesCollection(NAME).Select

Thanks
Brad

http://www.mrexcel.com/forum/images/buttons/quote.gif (http://www.mrexcel.com/forum/newreply.php?do=newreply&p=2072786)

[Bob Phillips]

This works for me



With ActiveSheet.ChartObjects("myChart")

.Activate
.Chart.SeriesCollection("Sales").Select
End With