Macro stops at random places and no error message

[David A Coop]

Hi Gurus, I need your help please.

I have a macro which stops for no apparent reason.

I get a dialog box which says "Code Execution has been interrupted". If I hit the Debug button, I can then hit F5 and complete execution.

The place the macro stops is random. The frustrating thing is that it happens most of the time, but sometimes it works as expected!

This workbook originated from a Forum Member who is a tennis fanatic - I am trying to come up with code to state the result of matches from the perspective of the named player in Column O. (The results are always stated from the perspective of the first named player).

It feels like a buffer gets full, and the thing just stops until you give it a push.

Any clues?

Regards,

David