Magic.

That worked perfectly, Thank You.

Now what I'd like to know, is how does one ever learn such a thing, and even
if you knew it existed, how would you look it up after you forgot the command
name?





"Just Another Yahoo!" wrote:

I'm not sure about what's going on but put this at the beginning of your
code:
Application.EnableCancelKey = xlDisabled

--
Toby Erkson
Excel 2003, WinXP

"Hydra" wrote in message
...
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?