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