Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Random Code Breaks 1

Status
Not open for further replies.

bdmangum

Technical User
Dec 6, 2006
171
US
Similar to this other thread (thread707-1145930) i'm having random breaks occur during execution of my code. I have very large file with several forms which load and unload each other. For some reason the code will decide to break at certain points for what appears to be no reason. The code works just fine when I press continue or play. Anybody know how to fix this?

Thanks
 
For a while this problem disappeared, now suddenly it's back. I still can't figure out what's happening. There are no code errors, yet it still has random breaks. Ideas?
 
The thing is Gerry is that it's not breaking at a certain point in the code. The file I have contains a very large macro. It spreads across many forms and sheets. It contains roughly 40-50 modules/forms.

For some reason, the code will simply break at random spots. For example I'll set a variable equal 3 and it'll break there for no reason. It doesn't seem to matter which Sub routine I run at some point it has a random break. The one similaritiy is that it always breaks only upon being called by another Sub.

The coding doesn't appear to be the issue, since it rarely stops the same place twice. Also as I noted in previous posts, when I press continue it runs exactly as it should. It's very strange.
 
I've had the same problem and posted as wel. I've had some responses as to what might be causing is, but they didn't apply in my case. With me it just stopped doing it after a while, allthough sometimes it still happens.

It seems to occur completely at random. You can do a search to find my post (actually, I think I pitched in on someone else's) to see what the responses were then.

Cheers,

Roel
 
Thanks! I think the code cleaner took away the problem, at least for the moment. It did shrink my file by 200kb (803kb to 603kb), so something changed. It seems as though after enough work on a code and enough implemented breakpoints the file gets corrupted somehow and begins to break on its own.
 




bdmangum,

You got lots of good tips over the past 3 days.

Don't you think that SOMEONE deserves to be [blue]thanked for a valuable post[/blue], more that just a "Thanks!"?

Check out the [blue]hyperlink[/blue] in the lower left of any such post.



Skip,

[glasses] [red][/red]
[tongue]
 
Right you are Skip! Actually I never knew about that hyperlink, apparently I've always just glossed over it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top