"Cannot run the macro" error

[marcheese]

Hello,

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

"cannot run 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

[gmr4evr1]

Is it possible that the problem is the double commas between False and ActiveSheet.Range("$D$60") and between the last 2 False?
Although, that may not explain the cannot run the macro error.

[marcheese]

Is it possible that the problem is the double commas between False and ActiveSheet.Range("$D$60") and between the last 2 False?
Although, that may not explain the cannot run the macro error.

Thanks for the response, but that is not causing the issue.

[gmr4evr1]

Probably not the problem, but has the macro setting been changed somehow? If that's not it, is that macro stored in a file that isn't open?

[marcheese]

Probably not the problem, but has the macro setting been changed somehow? If that's not it, is that macro stored in a file that isn't open?

No settings have been changed and the macro is stored only in the file I'm trying to run it in.

[gmr4evr1]

What is the file extension of the file?

[marcheese]

What is the file extension of the file?

.xlsm is the extension

[gmr4evr1]

Well shoot.

[gmr4evr1]

Your code is calling for an .xlAm file, could this be the error?

[marcheese]

Your code is calling for an .xlAm file, could this be the error?

I believe XLAM is the application being run. Like I mentioned previously, the macro works the first time, then subsequently fails.

[gmr4evr1]

Is the macro named regress or regression?

[marcheese]

Is the macro named regress or regression?

Regression

[gmr4evr1]

Just taking a stab here, but, the "Application.Run" line is calling for !Regress.....should it be !Regression?

[marcheese]

Just taking a stab here, but, the "Application.Run" line is calling for !Regress.....should it be !Regression?

Hah, thanks I tried that too but to no avail!

[gmr4evr1]

Well dang it! When I copied and pasted your code to one of my workbooks and changed it to !Regression, I didn't get the "cannot run the macro" error anymore. Of course I got another error, but I think that is because I don't have all the required info.

[marcheese]

Well dang it! When I copied and pasted your code to one of my workbooks and changed it to !Regression, I didn't get the "cannot run the macro" error anymore. Of course I got another error, but I think that is because I don't have all the required info.

Do you get the same problem where it works the first time then stops working after that?

[gmr4evr1]

Nope, I can't run the code at all because of the new error. I get a "Run-time error '450': Wrong number of arguments or invalid property assignment" message. That is why I think I don't have all the information needed to run the code properly.

[gmr4evr1]

Try separating the "Application.Run....From the , Active.Range by having the code on separate lines like the code here ...

Please Login or Register  to view this content.

When I ran it like this, it actually did something, but then gave me a different error, but, it did do something on the active sheet