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.

See http://www.google.com/groups?selm=MP...06d3ff898ad47%
40msnews.microsoft.com

or

http://www.google.com/groups?selm=MP...3f4cef498acb6%
40msnews.microsoft.com

Basically, the x values have to be a single 2D array.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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.