"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

Similar Threads

1004 error when using ATPVBAEN.XLAM!Regress 7
Big dataset - batch process 1
Using a command button to run a data analysis application 0
Data Analysis Tool 5
Calling Fourier plug-in from VBA 1
Run-time error when copying entire row! 5
"Run-time error '1004' 5
Recordin Regression as a Macro 1

Top