VBA jumping code

[JeffGrant]

Hi all,

I am looking for some feedback please. Periodically, VBA will completely jump a Call to another sub. There is absolutly no reason for this. If I run the code via F8 everything is fine. If I rerun the code, it works.

My issue is that if the Call is missed and I dont know about it, then I will be getting incorrect results.

I am not sure how I can even test for this.

This does not happen all the time, but it does happen frequently enough for me to be concerned about it.

Has anybody else had this problem?

Thanks in advance.

 

[Alex Blakenburg]

Does the code have an on error resume next in it ?
Try turning that off.

 

[JeffGrant]

Hi Alex, the error traping calls another error sub, not a resume next. Thanks for the suggestion.

It is just like vba is completely jumps over that particular Call statement.
cheers

 

[Alex Blakenburg]

It still sounds like there is an error and it is jumping the line, so either comment out the "On Error" line (unless it is goto 0) or in Tools > Option, change the setting to Break on All Errors.
(Just remember to change it back when you have finished trouble shooting )

 

[JeffGrant]

ok thanks, i'll give that a go.

cheers