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

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)
 

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

Top