LinEst embedded in VBA Function

W

Warren H

I am performing an iterative regression and am wrapping
the worksheet function LinEst in my own VBA function. I
want to pass LinEst a single column array of doubles for
the Yvalues and a two column Array of doubles for the
Xvalues. It works fine for a single column of Xvalues but
returns VALUE error when passed the two column array.
What are my work arounds? I would pass it range arguments
but I need to perform arithmatic on the Xvalues before the
regression.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using linest excel function from msaccess with multidimensional ar 4
Runtime Error 1004 on Linest in VBA 1
Need help with using LINEST() 3
Accessing individual elements of an array returned by a function 1
Type mismatch in VBA LinEst function if range too large 4
Custom function for max residual from linear regression 7
Changing select ranges in VBA 5
LINEST() function returns error. 1

Top