ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Code Execution Error (https://www.excelbanter.com/excel-programming/371654-code-execution-error.html)

Craig

Code Execution Error
 
I'm using Excel 2003. I've written a macro that goes through one thousand
lines of text, deletes the blank lines and inserts some columns. Nothing too
complicated...

When I was testing the macro, it ran fine. Now, all of a sudden, I'm
getting the "Code Execution has been interrupted" error every few seconds
while the macro is running. I mean, the macro curses down a few rows then
the message occurs. I hit "continue"...the macro resumes, then a few seconds
later - again with the message.

I have no idea what is causing this. I have no break points anywhere in the
macro.

Any ideas would be greatly appreciated.

Thanks.
C
--
Craig

Bob Phillips

Code Execution Error
 
Show the code.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Craig" wrote in message
...
I'm using Excel 2003. I've written a macro that goes through one thousand
lines of text, deletes the blank lines and inserts some columns. Nothing

too
complicated...

When I was testing the macro, it ran fine. Now, all of a sudden, I'm
getting the "Code Execution has been interrupted" error every few seconds
while the macro is running. I mean, the macro curses down a few rows then
the message occurs. I hit "continue"...the macro resumes, then a few

seconds
later - again with the message.

I have no idea what is causing this. I have no break points anywhere in

the
macro.

Any ideas would be greatly appreciated.

Thanks.
C
--
Craig





All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com