Hi all,

I have written vbs codes to run a linear regression – 5 independent
variables. I want to get regression result print in the spreadsheet
where the data is and the statistics for regression are the same as
result from analysis tool package…

I know Regression= Application.LinEst(y, x, True, True) should be use,
but no idea how to get regression output to a spreadsheet.Could
someone please provide some solutions?

Thanks a ton

Fei