View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default Debug Step vs Run Mode

Arthur,

Do you have any error handling that causes it to bypass code?

Post the code and give details.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Arthur" wrote in message
...
SubB is called from SubA. My problem is the return to SubA
seems to occur prematurely - before executing all the code
in SubB. I cannot see anything in SubA or SubB to cause
this.

I placed a messagebox as the last line of code in SubB
just to see if it was getting there. Sure enough - no
Messagebox pops up in runtime. Aha, now I'm on to
something, right?

To debug it further, I placed a breakpoint at Call SubB,
and stepped the rest of the way through SubB. Here's what
happens - EVERY LINE of SubB code executes in step mode,
right up through the messagebox. Honest!

I'm baffled. Any ideas?

Art