I have posted an enhanced version of code originally posted by David
Braden. See the google.com archive at
http://groups.google.com/group/micro...rting/msg/0eda
30f29434786d?hl=en&

For an alternative approach see
Trendline coefficients
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...
Having produced a trendline and have the equation displayed on the chart,
is there any way of displaying that equation on the excel sheet itself. I
need to have the chart hidden yet require the equation to update different
inputs.