Tryed to use this code to return color index of series in order to set color of trendline to same color but doesn't seem to be working. Any suggestions?
Dim TrendLineColor as Long
TrendLineColor = Sheets("Chart1").SeriesCollection(Arg1).Interior.ColorIndex
Dim TrendLineColor as Long
TrendLineColor = Sheets("Chart1").SeriesCollection(Arg1).Interior.ColorIndex