Intermittent error: "Excel has stopped working" while looping across all Spreadsheets

Hello,

I am getting Intermittent error: "Excel has stopped working" while looping across all Spreadsheets even running in safe mode. It is pretty weird because it happens at some time frequently and suddenly it stops for some time. I am suspecting this issue is related to the loop code I am doing across all Spreadsheets. Can anybody help me to see if there is any issue on the below loop code that might cause this issue?

When I run each Spreadsheet individually(without using the below code to loop), I DO NOT receive any error...

Please Login or Register  to view this content.

Does anybody have any better code to loop across all Spreadsheets like the way I am doing above?

Thanks!

Sometimes I am getting: "Run-time error '9' - Subscript out of range in this part of above code:

Please Login or Register  to view this content.

Looks like it switches to the master Sub AllWorkbooks() and it does not find the Sub Startx which is in the other Spreadsheets where the loop is being made.

What does the macro Startx do?

The Startx macro updates several worksheets, makes a SQL Query, brings data to the worksheets and insert some formulas to make summary of data brought by SQL, but, it has worked perfectly running individually, it never issued any error....
I have found that the issue happens whenever the Startx macros ends and then this master one(AllWorkbooks) tries to save the Workbook of Startx macro, and then the Excel stops working....I am almost sure the issue is in this middle:

Please Login or Register  to view this content.

Do all the workbooks have the Startx macro?

Is it the same code for each workbook?

Have you considered running the Startx code from the workbook the AllWorkbooks code is in?

What I'm suggesting is you move the Startx macro to the same workbook as AllWorkbooks.

Then when you open each workbook you run Startx from the workbook AllWorkbooks is in on the workbook you've just opened.

I was suggesting have one Startx in the AllWorkbooks workbook.

Hey Norie,

Thanks for all your suggestions!
I think I found where the issue is! Looks like after Selection / Number.Format in one of the modules is causing that.
I removed all the Number.Formats and I am testing. So far, after 10 runs I did not receive any error: "Excel has stopped working..."

I will you let aware if all goes well.

Can you post an example of one of your Startx macros?

I've go a feeling that they could be tidied up a bit.

Here it is:

Please Login or Register  to view this content.