Error - "Cannot run the macro"

Hello,

I've created a macro to run regression analysis under the data analysis option. The first time I enter my keyboard shortcut (CTRL+SHIFT+R), the macro works fine. When I try re-entering the shortcut, I get the following error:

"cannot run the macro the macro ". The macro may not be available in this workbook or all macros may be disabled"

Here is my code:

Please Login or Register  to view this content.

When I choose to debug the error, "application.run" to the last "false" is highlighted in yellow so this is where I assume the error is. I'm just not sure why the macro would run fine the first attempt, then fail after that.

Any help or advice would be appreciated!

Thanks

Regression Test.xlsm

Originally Posted by shg

Excel Options > Add-Ins > Go > tick Analysis Toolpak - VBA

Thanks, but that option is already ticked. As I mentioned, the macro works the first time, but then the error comes up the second, third, etc. time.

Originally Posted by shg

Works fine for me in Excel 2010, and I don't have Excel 2007 installed to test, sorry.

What particular part of the result do you need? You could just use LINEST to get most of them.

I'm just looking for y intercept and slope basically. Never used LINEST before, will this get me the result I'm looking for?

Perfect, this worked much better!

Thank you!