Hey experts,

This is not the regular question when I need to do something and you guys suggest possible solutions. I'll explain:

I have a big Macro that is run by more than 100 people every day. Around 2 times per month, when one of the functionality is run, the Macro doesn't perform the task as required, but if the Macro is run again, right after, it completes successfully. This can happen in any computer under any situation. I haven't found a pattern that drives me to conclude what the problem is. I recently update the code to calculate the Sheet data more often in case the calculations set to Manual were the problem but it seems like that didn't work.

The main idea is not that you guys tell me what is specifically wrong (although that will be perfect) but to know if you have read any documentation that talks about this Random, hard to debug errors. It's pretty hard to catch the bug since there's no error, just bad functionality. And it is also pretty bad when the problem is seen very randomly and you can only update code and expect the error doesn't show again.

Have you guys know anything that could help me grow in this area?


Thanks a lot.