bradh_nz
09-27-2009, 06:02 PM
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)
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)