Thread: Regression
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ubirajara Augusto Ubirajara Augusto is offline
external usenet poster
 
Posts: 1
Default Regression

I am trying to automate running of regression macros in Excel. I used the
"record" method to create one. But everytime I run the "recorded" regression
macro, I get the error message:

"Macro 'ATPVBAEN.XLA!Regression' could not be found.

Code:

Application.Run "ATPVBAEN.XLA!Regression", ActiveSheet.Range("$B$2:$B$50"), _
ActiveSheet.Range("$A$2:$A$50"), True, True, 95, "AUX44", True,
True, True _
, True, , True

What can I do?

Thanks.