Calling Regression Toolpack in a Macro

[Phil]

I want to call the Regression capability in Excel's Data Analysis Tool Pack
from a VBA macro. I have checked atpvbaen.xls in the Reference pulldown menu
item in the macro and Tool Pack VBA in Add-ins. The call syntax begins with
Application.Run "ATPVBEAN.XLA!Regress" , but how do I find what the
remaining parameters are to include in the call, including specifying the
input and output ranges?

Thanks for your help
Phil

 

[Guest]

Record a macro while you use the ATP menu system to call the regression tool.
Then examine the recorded syntax. Depending on what you want, it may be
simpler to use LINEST, which is the fundamental calculation engine underneath
the ATP regression tool.

Jerry