I'm not understanding what you mean by ran it about 8 times and what you mean by deleting everything.

Are you creating a TEMP TABLE with the rows you want to process? Could you show some real code so I can grasp this a bit better?

I'm not a VBA person - so maybe I'm confusing something in regard to that.