Hello! Just registered to this forum, it seems very interesting and helpfull.

I want to do some regressions on excel (about 900 regressions). I know nothing about vba or macros.

I want to run a regression of Y for every Xi variable
Y X1 X2 X3 Xn

I found this 
Application.Run "ATPVBAEN.XLAM!Regress", Sheets("sheet1").Range("$H$3:$H$10"), _ 
Sheets("sheet1").Range("$I$3:$K$10"), False, False, 99, "output23", True, True _ 
, True, True, , True
at ozgrid.com forum, which seems to work, as I get the same results with running the regression with the add-in tool. I read that you can repeat the macro process.

How I must modify it to run it for all my Xi variables?

Also, is there a way to choose if I want to receive the results on the same sheet, or every regression on new sheets, or new books?

Thank you!