View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hydra Hydra is offline
external usenet poster
 
Posts: 38
Default Code Execution has been interrupted

I added a couple of dummy statements after the find statement, that don't
affect the code (move to the next cell and thn move back) and I have the same
problem.

In other words it seems to hang up after the find statement.

"Hydra" wrote:

Still having a problem with this.
As long as I hit the continue button, the code executes perfectly.

It is running a loop with a find statement in it, and then it writes the
data to an array vaiable. That is where it ususally, but not always hands up.

I tried putting in a wait statement so it could catch up, but no luck.

It executes the loop 3,4, 5, 6 times, and then hangs up.

Any more suggestions?