Thread: calling subs
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 216
Default calling subs

I would show the code but it’s long and messy. I already
did the break point and "f8" thing and it literally steps
over the call. I set the break point one step in front of
the call command then I hit f8. The call is highlight
then I hit f8 again and the next line after the call is
highlight. Maybe I will strip out all the code in the
call sub then put a msgbox("") command to see if it will
ever go to that sub.





-----Original Message-----
Do this: Set a breakpoint on the line preceding the

calling of the
subroutine. Run the code and when it reaches the

breakpoint it will
stop and show you the highlighted line with the

breakpoint. Press "F8"
to step through the code one line at a time. This will

show you
exactly what is happening as the program runs, whether

the subroutine
is actually being skipped or if there is a bug in the sub

itself that
causes it to look as though it is skipped. Beyond that

we must have a
look at the code to tell you more. - Pikus


---
Message posted from http://www.ExcelForum.com/

.