excel for mac crashes when running macro

#Excel for mac crashes when running macro code
#Excel for mac crashes when running macro Pc

Then for good measure, went back through each of the other modules where I had several variables declared as Global just in case needed elsewhere.changed them all to Private. I was liberally (and of course stupidly) declaring most variables as global thinking it would be convenient if I need to use them in a different module. Came back after a weekend and started crashing (when running the last module). This is a really old thread but I found my mistake by accident misreading something and ended up coming up with my solution, so posting for others. I'm still not sure why declaring variables as Global would cause the crash.maybe there's a limit to how many the program can store?!? Anyway.my problem solved and lesson learned. Then for good measure, went back through each of the other modules where I had several variables declared as Global 'just in case' needed elsewhere.changed them all to Private. Turned out, didn't need any of the variables for that module anywhere else, so changed them to 'Private' and lo and behold, the macro stopped crashing.

I was liberally (and stupidly) declaring most variables as global thinking it would be convenient if I need to use them in a different module. Reading about variable declarations here, I thought of my Globally declared variables in the module where crash was occurring. Tried to debug and there was no reason for it to crash at the location it was crashing. Came back after a weekend and started crashing. This is a really old thread but I found my mistake by accident 'misreading' something and ended up coming up with my solution, so posting for another wanderer.

#Excel for mac crashes when running macro code

I found some previous posts that recommended changing code like this: It's terribly frustrating since there is NO error message, no run-time error, nothing to show me what goes wrong. This same error happens when I go to Debug>Compile in VBA. But, anytime that I try to run the master macro, or the subroutines that pull information from worksheets (esentially, anything involving my public variables), the whole thing crashes. I've tested a few of the subroutines, and the simple ones that clear individual worksheets to zero-out the calculations work just fine with no lock-ups. All of this worked before the weekend, and I have NO idea what could have changed. Same deal with a button on a worksheet that I have assigned to the master macro. Similarly, when I open the workbook and go to the Developer Tab>Macros, the file crashes when I just simply click on the name of the master macro. Now, when I try to run the macro through hitting the Play button in VBA, Excel/VBA locks up with no error message. I have the calculation procedures split over multiple smaller macros that perform the actual calculations.Įverything was working fine until I came in after the weekend.

#Excel for mac crashes when running macro Pc

Help! I've been building a large macro for 2+ months on a PC with Windows 7 and Excel 2010.