If you continue to have trouble with the Analysis toolpak regression, there's other regressions around such as Excel's LINEST, or available elsewhere on the internet, or I've probably got one on my computer somewhere.Īs one further point, I see you specify your output range as being on the ActiveWorksheet but not your input ranges. That could suggest that the problem is really elsewhere in a part of your code that you haven't posted. Have you tried what I did in my opening paragraph above, where I was unable to get your error. If it does work manually, then have you tried recording the steps using the macro recorder? without the macro attempt, to ensure that it really is the macro at fault?
Have you tried running the regression manually, i.e. I copied your code into a module, filled range CE2:CF10 with some random numerical data, ran that bit of code, and it worked quite OK.
0 kommentar(er)
