| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Regression Toolpack in a Macro
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recordin Regression as a Macro | New Users to Excel | |||
| calling a macro | Excel Programming | |||
| Problem seting-up Regression Macro | Excel Discussion (Misc queries) | |||
| Calling a macro from a key | Excel Programming | |||
| Looking for a macro to curve fit using multiple regression | Excel Programming | |||
Threaded Mode
