Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recordin Regression as a Macro
Hi,
I cant seem to record a regression as a macro and apply it to a "button"... Wat i did: Started "Record New Macro", started "Relative Referencing"... den i went to "Data Analysis", "Regression" Entered the X & Y input values using "Ctrl, Shift, Down" "Stop Recording" Applied to "button" but, it showed "run-time error 1004" ATPVBAEN.XLA could not be found. can someone help mi? went to editor and tis is as follows: Sub Macro2() ' ' Macro2 Macro ' Macro recorded 10/31/2005 by Psychotic ' ' Application.Run "ATPVBAEN.XLA!Regress", , , False, True, , , False, _ False, False, False, , False ActiveWindow.SmallScroll Down:=-30 End Sub |
#2
|
|||
|
|||
Hi,
i juz realised tat i need to install the add-in: Analysis ToolPak-VBA However, i encountered another problem... it said "input Y range missing. pls enter". Ani help? did i do sumtink wrong when recording the macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Problem seting-up Regression Macro | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |