Thanks Michel

Your solution works fine for a simple X array. The problem arrises when x is
a 2D array - which is what I need

"michelxld" wrote:

>
> Hello
>
> for the linest Function , you may try
>
>
> Dim y_connus(), x_connus()
> y_connus = Array(5, 2, 1)
> x_connus = Array(6, 3, 4)
> Range("A1") = WorksheetFunction.LinEst(y_connus, x_connus)
>
>
> Regards ,
> michel
>
>
> --
> michelxld
> ------------------------------------------------------------------------
> michelxld's Profile: http://www.excelforum.com/member.php...o&userid=17367
> View this thread: http://www.excelforum.com/showthread...hreadid=496012
>
>