Excel Crash Upon Running Macro

[MrPartial]

Hello guys! I'm having a problem. Literally out of nowhere, one of my macros is crashing excel (turns to not responding) upon execution. The part that is stumping me is I didn't change anything from the last time I used the code (which worked flawlessly), and my colleague CAN run the code on his computer without any problems. Did something change in my computer settings? It's not giving me a error when I attempt to run macro, however when I sent the workbook via email and tried to open it, I got "Error in loading DLL", which i've researched and troubleshot to no avail. Thanks for any ideas fellas

Please Login or Register  to view this content.

[Arkadi]

I doubt it is the cause, but you really should try to avoid all those select... activecell switches... instead of code like:

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

That applies to almost the whole macro including .style .interior, etc., and with that much going on, it may or may not solve it, but it should make some improvement.
Turning off displayalerts is also not very common unless doing it for a specific reason.

[Arkadi]

In VBA editor, check references... are any marked "missing"? It is possible that there is a reference from a newer excel version, and you may need to remove the reference and add an earlier version.

[MrPartial]

Arkadi,

One is "Missing: Microsoft Outlook 16.0 Object Library" ... should I uncheck this?

[MrPartial]

I doubt it is the cause, but you really should try to avoid all those select... activecell switches... instead of code like:

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

That applies to almost the whole macro including .style .interior, etc., and with that much going on, it may or may not solve it, but it should make some improvement.
Turning off displayalerts is also not very common unless doing it for a specific reason.

Yeah good call thanks for the tip. I'll try to make that change, but again my colleague right next to me is running the macro perfectly fine

[Arkadi]

The missing reference is probably the source of the dll error. Yes I'd uncheck it.. Different office versions will reference different libraries, but newer versions are backwards compatible so if you do need the outlook library add a reference to 15 (which corresponds to office 2010) instead of 16 and it should work on later versions too.

As for working on a colleagues machine but not yours, sometimes freezing or hanging are caused by issues that are not code related... RAM amount, or harware issues, cpu, corrupted software, can all play a role. Making the changes may not solve the issue but makes the code better, and if you are lucky helps the problem. If the above dont help we can dig deeper.