VBA Data Analysis Loop Problem

[darr]

Hi Everyone,

I have a macro which runs 25 uni-variate regression using Excel's data analysis. However in writing this macro I manually changed all of the cell range values where the data is in my spreadsheet. I want to integrate a loop into my code in order to speed up the process, have a more efficient macro and be able to perform 200+ regressions multiple times. I do not know what type of loop I should use or how to address the ranges when compiling the loops. My code is as below:

Please Login or Register  to view this content.

This cell range moves up one column each time and I want to be able to continue this trend multiple times. Any help would be much appreciated as I am unfamiliar with loops and new to VBA. Thanks very much for any help!

Regards,

D.

[JBeaucaire]

Give this a try:

Please Login or Register  to view this content.

[Palmetto]

Cross posted at Ozgrid: http://www.ozgrid.com/forum/showthread.php?t=155875

VBAExpress: http://www.vbaexpress.com/forum/showthread.php?t=38200

MrExcel:http://www.mrexcel.com/forum/showthread.php?t=563239