Mike---
You might be interested in code that I posted some time back; link (allow
for wrap) is
http://groups-beta.google.com/group/...0d 271303e0d6

If you Google under the newsgroups for microsoft.public.excel.*, author =
Braden, words contain "trendline", you can get a sense of community effort
and thought leading to the code. You *will* need to watch out for line
breaks that happened with the posted code. Sorry about that. I also posted
code back in 1999 to extract the numbers, but the later post (2003) works
more as a function. It is intended to get around then-extant problems with
LINEST; I don't yet know if these problems have been fixed with the Office
SP1 update, but given Microsoft's response time to fixing other problems
with Excel, I sorta doubt Linest is working well.

HTH
Dave Braden


"mikerr" wrote in
message ...

That's what I was hoping for. Thanks!


--
mikerr
------------------------------------------------------------------------
mikerr's Profile:
http://www.excelforum.com/member.php...o&userid=25830
View this thread: http://www.excelforum.com/showthread...hreadid=392109