you can't. Only a variant can be assigned an array and Linest is returning
an array.

--
Regards,
Tom Ogilvy

"RyanVM " wrote in message
...
Tom Ogilvy wrote:
*See answer to you later posting of this question. When you apply
the power
function to the B column, you get a 2D array and 2 x2730 is greater
then
5461 which is the limitation in xl97 and xl2000. See second article
cited
in the response.

--
Regards,
Tom Ogilvy* Thanks for the help once again.

How would I go about defining CurveFitParams so it's not of the Variant
data type. I'm assuming as an array?


---
Message posted from http://www.ExcelForum.com/