Regression Macro - will not run

[Mariner191]

Mr. Excel,

This simple Regression macro returns the message"Run Time Error 1004, Method 'Run' of Object'_Application' failed. The underlined code returns highlighted in yellow, by Debug.

Please advise.

Thank you,
Mariner191


Application.Goto Reference:="R9C33"
Application.Run "ATPVBAEN.XLAM!Regress", ActiveSheet.Range("$AH$10:$AH$110") _
, ActiveSheet.Range("$AG$10:$AG$110"), False, False, , ActiveSheet.Range( _
"$AK$10"), False, False, False, False, , False
ActiveWindow.SmallScroll Down:=-7
Application.Goto Reference:="R9C33"
End Sub