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

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?