ExcelBanter - Interruption?

The first time it happened was yesterday.

I had a list of 20,000 thousand calls. Rather than delete the ones I didn't
want, I thought I'd run a macro to count the ones I did to save on formulas
and calculating time.
I had the macro run though i = 5 to 20,010, and if cells(i,5) was less than
30 then I'd set rang = i & ":" & i and select rang and delete it.
When I ran the macro it looped to about row 300, deleting a few lines along
the way. Then that error showed up, since I could find nothing wrong with the
code (hell, it had already cycled 300 times) I just hit continue and it
continued to about row 450 and the same again. After hitting continue each
time it happened to row 1000 I got bored and did it manually with a sort and
such.

Second time it happened I had excel crash on me, then whenever I tried to
reopen it I got the error straight away, when it was trying to add a menu
with a command to a userform. This stopped erroring when I logged out and
back into the computer.

As far as I can tell, this error never pops up on anything I've done, but
something the system is doing, or Excel, or something...

"Tom Ogilvy" wrote:

http://support.microsoft.com/kb/146864/en-us
Error Trapping with Visual Basic for Applications

Don't know if that helps, because I don't know what you are doing.

--
Regards,
Tom Ogilvy

"PaulW" wrote:

I've started getting the error "Code Execution has been interrupted" but I
don't have the first clue what might be interrupting it... I'm pretty sure
it's nothing i'm doing.