VBA to blow away any and all trendlines in a chart

Good Afternoon All!

I use the following to blow away any present data series in a particular chart:

Please Login or Register  to view this content.

Is it possible to do the same for any trendlines instead?

What I am doing is providing the user with radio (option) buttons to select which of three data series lines present on a chart they want displayed. Before running the code to display the trendline, I want to clear all trendlines, if present (which brings up another question - do I have to first test for the presence of the trendline or can I just use "On error resume next" for the cycling?). I have found it cleaner to do this instead of including the "If the button is false, then delete the trendline" method.

In any circumstance, able to help or not, HAPPY SUNDAY!

Though I have come up with the following, I am wondering if there is a way to address the trendlines without the clumsy cycling of each data series-

Please Login or Register  to view this content.