PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup "ATPVBAEN.XLA!Regress", Run-time error '1004'

Reply

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

 
Thread Tools Rate Thread
Old 16-07-2003, 09:50 AM   #1
Anders Thrane
Guest
 
Posts: n/a
Default "ATPVBAEN.XLA!Regress", Run-time error '1004'


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("D36").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)

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off