For my enhancements to Dave Braden's code:
http://groups.google.com/group/micro.../msg/0eda30f29
434786d?hl=en&

To get the results directly in a worksheet:
Trendline Coefficients and Regression Analysis
http://www.tushar-mehta.com/excel/ti...efficients.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
When a linear trendline is added to a chart, the linear equation which best
fits the data can be displayed. It takes the traditional form of y=mx+b. Is
there any way to programatically capture the values of "m" and "b"?