My first thought -- is there a reason for running this in VBA? The Regress utility is built on the same linear regression algorithms as the LINEST() worksheet function. Unless there is some reason for doing this in VBA, my first inclination for linear regressions is to perform the regression with the LINEST() function and not use VBA at all. https://support.office.com/en-us/art...a-fa7abf772b6d

Even when I choose to do the regression in VBA, I will usually call the LINEST() worksheet function rather than use the regress utility. http://www.cpearson.com/excel/Callin...ionsInVBA.aspx