Return a Moving Average trendline value?

[FredMFoley]

I have a chart with a moving average trendline (eg 150 days)

Can I use VBA to determine the moving average value?

These two lines select the moving average trendline

ActiveSheet.ChartObjects("Daily Chart").Activate
ActiveChart.SeriesCollection(1).TrendLines(1).Select

but I'm stuck finding code to return it's value (150)

Hope someone can help.

Thank You

Fred