I create a trendline and give it the name of "Trend_1"
Later I want to delete/modify this line by referring to it by name (not index number which I think can change).
Can I do this?
Des
I create a trendline and give it the name of "Trend_1"
Later I want to delete/modify this line by referring to it by name (not index number which I think can change).
Can I do this?
Des
Perhaps something like this:
[VBA] Worksheets("sheet1").ChartObjects(1).Chart.SeriesCollection(1) _
.Trendlines.delete Type:=xlLinear, Name:="Trendline1" [/VBA]
Peace of mind is found in some of the strangest places.