"Code execution has been interupted"

[Dennis Fry]

I have been an amateur VB programmer for several years and I have
never encountered this problem. When executing my macro, I get an
error message that states "Code execution has been interupted" (no
error # indicated). When I hit CONTINUE it typically completes the
macro normally. When I hit DEBUG it shows that the program has
discontinued in a different portion of the macro each time. When I
Step Into (F8)the program it executes perfectly. I have entered On
Error Resume Next code for each subroutine. The kicker is, sometimes
it works correctly. Any thoughts or comments will be appreciated.

Dennis

 

[Tom Ogilvy]

Are you hitting the escape key - perhaps inadvertently.

 

[Dennis Fry]

Tom,

I wish it were that easy, but I am quite certain I am not hitting the
escape key. As a matter of fact, I ran the macro 10 - 15 times. It
worked correctly twice. The rest of the times it stopped at a different
location in the code each time. Thanks for your help, though and if you
have any other thoughts I would love to hear them.

Dennis


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!