VBA Arrays and Exponential fit calculation - Excel 2010

[cwunderlich]

I have a macro which stores 10 values into an array (these are years, aka "known x's"). It also stores 10 values into a different array (these are data points, aka "known y's"). I plot these points to a scatter plot in excel and add an exponential trendline with the trendline formula displayed. The trend line formula gives me something along the lines of: 8E+79 e^(-.093x). What I want as a variable in my macro is this trend number of -.093. I have played around with growth(), linest(), logest() in excel to try to reproduce this -.093 number from the two data arrays as input, but no luck. Can someone please help me here?

Thanks,

 

[cwunderlich]

Nevermind, I think I solved it.

LINEST(LN(known y's),known x's) seems to do the trick