A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Code Stops Running Instead of Debugging



 
 
Thread Tools Display Modes
  #1  
Old December 10th, 2008, 03:05 PM posted to microsoft.public.excel.misc
[email protected]
external usenet poster
 
Posts: 138
Default Code Stops Running Instead of Debugging

Several times now I've seen modules run until they hit an error and instead
of going into break mode and allowing me to debug the errors the code just
stops running. This is a problem because it seems that the entire module ran
and is then finished, however it only partially ran. Any ideas as to why
this happens or what I can do to stop it?

Thanks

Adam Bush
  #2  
Old December 10th, 2008, 07:15 PM posted to microsoft.public.excel.misc
Luke M
external usenet poster
 
Posts: 2,672
Default Code Stops Running Instead of Debugging

Some errors in VBA cannot be fixed in debug mode, so the program does not
give you the option to fix it. And yea, I also find this annoying.

The simpler solution might be if some type of error handler has been
written, such as on error resume next, goto, etc.

My suggestion would be to go through the code manually, using step-by-step,
or step-to if you have an idea where the problem is.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


" wrote:

Several times now I've seen modules run until they hit an error and instead
of going into break mode and allowing me to debug the errors the code just
stops running. This is a problem because it seems that the entire module ran
and is then finished, however it only partially ran. Any ideas as to why
this happens or what I can do to stop it?

Thanks

Adam Bush

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.