Excel crashing on macro execution

[Keith74]

Hi There

I have a collection containing about 34000 items and a for each loop
that runs for every item in the collection to update in individual
record in a sql database. For some reason excel hangs everytime i run
the code, the code itself works fine when you step through it but
excel goes boom left to its own devices. Any ideas ?????

cheers

Keith

 

[Keith74]

Worked it out.

The code was actually still running but because it was using all its
capability on the macro it was "Not Responding" to any user action
while the code was running.