Maesters,
My code had been running normally for least 50+ times. I was writing some really simple follow-up codes which I'm 100% sure that have nothing to conflict with my main sub. All of a sudden, as I retested my main sub, 1004 error occurred. Another command button containing another sub stopped working as well. But for this command button, the sub assigned could be run in the VBA editing window.
Anyways, I saved file, which meant if there was an error, it would have been saved as well, and closed all excel windows. I reopened and found that the codes were back to normal again.
So what is the problem behind all these and how do I prevent it from happening again ? Or is it just one of the many glitches that can't be avoided?
My code had been running normally for least 50+ times. I was writing some really simple follow-up codes which I'm 100% sure that have nothing to conflict with my main sub. All of a sudden, as I retested my main sub, 1004 error occurred. Another command button containing another sub stopped working as well. But for this command button, the sub assigned could be run in the VBA editing window.
Anyways, I saved file, which meant if there was an error, it would have been saved as well, and closed all excel windows. I reopened and found that the codes were back to normal again.
So what is the problem behind all these and how do I prevent it from happening again ? Or is it just one of the many glitches that can't be avoided?