Macro Causes Excel to Restart

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Incidentally you don't need all those .Select statements, they just slow things down, although it won't be those that cause the workbook to close.

Hi,

The idea was that you would upload the workbook that was crashing, not one that doesn't.
We can't test what might be failing otherwise.

That said your error handler which directs program flow back into the loop is bad programming practice, particularly if you've no idea what error might arise.

Just a guess but you could have entered a runaway loop from which never finishes and Excel just runs out of memory and gives up.

@Richard:

That said your error handler which directs program flow back into the loop is bad programming practice, particularly if you've no idea what error might arise.

Am I missing something? What error handling?

Originally Posted by TMS

@Richard:
Am I missing something? What error handling?

Mea culpa.

Quite correct. I had another workbook open at the time and clearly looked at the wrong one in the VBE Project window.

Thanks for the correction.

Originally Posted by ibuhary

Hi Richard,
I am sorry, the original file cannot be uploaded as there is confidential information in there.
The macro was running fine until last week.
I haven't done any structural changes in the file or in fact no change in macro codes at all.
Anyhow thank you for your time and feedback.
I will try to figure out what's going on by breaking the code and run it line by line.

BR,

Just anonymise the data. It doesn't matter how many M. Mouse or D. Duck names you have.