Macro for incorporating linear regression analysis

Hi all

I'm currently working on a project where I am building a forecasting tool using historical sales data. I'm attempting to automate the regression analysis within the workbook and I am encountering the following error:

Error message: "Regression - Input Y range missing. Please enter."

     Application.Run "ATPVBAEN.XLAM!Regress", , , False, False, , , False _
        , False, False, False, , False
    ActiveWindow.SmallScroll Down:=9

When I run the regression in the data analysis tab, everything comes out fine, however, when I record my macro using the exact same steps, and attempt to duplicate the regression with the macro, it doesn't seem to work. My VBA knowledge is quite weak, so any guidance would be appreciated!

Thanks