Regression

I am running a regression using visual basic,

Application.Run "ATPVBAEN.XLA!Regress", Range(Range("poolTbl").Cells(i, 8)), _
Range(Range("poolTbl").Cells(i, 9)), False, False, ,
Worksheets("Result").Cells(myRow, 1), False, False, _
False, False, , False

Things were working fine. But at some point, I started receiving the error:

The macro '' cannot be found

Any idea why this is happening?
Thanks

Do you have the "Analysis ToolPak - VBA" add-in checked (worksheet Tools
menu) and the ATPVBAEN reference checked (VBA Tools menu).

More to the point, why are you using a canon to kill a fly? With only two
y-values and no x-values,
slope = Range("poolTbl").Cells(i, 9) - Range("poolTbl").Cells(i, 8)
intercept = 2* Range("poolTbl").Cells(i, 8) - Range("poolTbl").Cells(i, 1)
Rsq = 1
Ssreg = slope^2/2
and all other quantities returned by LINEST are zero, except for F which
involves division by zero.

Jerry

"Antoine" wrote:

> I am running a regression using visual basic,
>
> Application.Run "ATPVBAEN.XLA!Regress", Range(Range("poolTbl").Cells(i, 8)), _
> Range(Range("poolTbl").Cells(i, 9)), False, False, ,
> Worksheets("Result").Cells(myRow, 1), False, False, _
> False, False, , False
>
> Things were working fine. But at some point, I started receiving the error:
>
> The macro '' cannot be found
>
> Any idea why this is happening?
> Thanks

Yes, I do have the analysis tool pack checked.
I guess I will go with your suggestion.
Thanks!

"Jerry W. Lewis" wrote:

> Do you have the "Analysis ToolPak - VBA" add-in checked (worksheet Tools
> menu) and the ATPVBAEN reference checked (VBA Tools menu).
>
> More to the point, why are you using a canon to kill a fly? With only two
> y-values and no x-values,
> slope = Range("poolTbl").Cells(i, 9) - Range("poolTbl").Cells(i, 8)
> intercept = 2* Range("poolTbl").Cells(i, 8) - Range("poolTbl").Cells(i, 1)
> Rsq = 1
> Ssreg = slope^2/2
> and all other quantities returned by LINEST are zero, except for F which
> involves division by zero.
>
> Jerry
>
> "Antoine" wrote:
>
> > I am running a regression using visual basic,
> >
> > Application.Run "ATPVBAEN.XLA!Regress", Range(Range("poolTbl").Cells(i, 8)), _
> > Range(Range("poolTbl").Cells(i, 9)), False, False, ,
> > Worksheets("Result").Cells(myRow, 1), False, False, _
> > False, False, , False
> >
> > Things were working fine. But at some point, I started receiving the error:
> >
> > The macro '' cannot be found
> >
> > Any idea why this is happening?
> > Thanks