"ATPVBAEN.XLA!Regress", Run-time error '1004'

  • Thread starter Thread starter Anders Thrane
  • Start date Start date
A

Anders Thrane

Hello

We have got a problem?
We have recorded a macro with the analysis toolpak,
dataanalysis and regression. But we are not able to play
it afterwards. The macro looks like this:

Range("D3:D6").Select
Application.Run "ATPVBAEN.XLA!Regress",
ActiveSheet.Range("$D$3:$D$6"), _
ActiveSheet.Range("$E$3:$F$6"), False, False, ,
ActiveSheet.Range("$D$9") _
, False, False, False, False, , False
End Sub

We get the following error message:

Run-time error '1004'

Hope some one has the solution to this problem. We would
be very pleased if someone has a solution

Anders and Jacob (Denmark)
 
Back
Top