View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
[email protected] rodwellm@gmail.com is offline
external usenet poster
 
Posts: 5
Default Extracting Trendline Coefficients

I am trying to use Tushar Mehta's version of the trendline coefficient
extraction code, which I found he
http://www.tushar-mehta.com/publish_...nalysis/16.htm
My problem is that for some reason if I save the file and reopen it,
Excel locks up and the TLcoef and TLeval formulas return "Err: No
trendline found"

What is wrong? Should I be changing something in the code?

FYI - i'm using Excel 2002.