VBA: performance problem, Excel not responding

Hello,

I have an Excel performance problem while executing VBA.
My guess is that this may be related to the high volume of lines to be treated (approx. 100,000) in 1 file (A), however, this did not occur before. Would this be a reason why Excel stops responding?
How can I find out the rootcause during this execution? It seems that the new lines that are written in file B, based on file A, stall and that the last line keeps repeating.
Thank you for your help.

It is hard to tell without your code (even then it is often hard to tell without your workbook).

Assuming you're looping, you can add:

Please Login or Register  to view this content.

Inside your loop, and instead of "Show That I'm Working!" have it equal a loop counter. Then run your macro from your workbook (and not from the VB editor) and you will see in the bottom left corner your loop counter.

On the other hand, if what you suspect is true, the last few lines of your code which keeps looping while not doing anything needs to be inspected.

Thank you both for your suggestions and feedback.

I'm going through my code in steps, adding stops and at times going step by step using F8.
I also added your suggestion Steven with a loop counter. It seems that this is difficult though, because I'm using various files (1 for sourcing and 1 newly created) and the loop counter doesn't seem to know what to count, even though I put in the correct unique identifier. (So Excel shows "Identifier1" instead of the counter.)
Here are more details of the As Is situation: I'm going through 2 loops and both give me the message of 'Excel not responding'. So I'm wondering if there is a way to go through the loops in batches, meaning for example per 10K lines for a total of 100K lines (so using 10 steps or repeats). In this case vba would only start the next batch of 10K lines when the previous one is finished. It seems that in that case Excel would be able to handle this?
Any advice is very much appreciated. Thank you.