Sub jumps to a function in a separate module without reason (to me)

[plaforte]

Hello, I have isolated a problem that I have for the last 6 hours. This sub will jump to a personal function without no reason (to me). It occurs once, every time that I change something in the sub, as a test, the change was only to "comment" or "uncomment" the "if" statement block or the next line instruction, in both cases this would repeat the same behaviour but only once and at the next execution, it does not jump. I can see this problem only when in "step into" mode.

This is as much info for which I could find a pattern. I join the sub and the function to which the sub randomly jumps to. The jump occurs from different line in the sub, not always from the same line. The function code is in a separate module from the sub

Thank you for your help
Pierre

THIS IS THE SUB CODE. I have trimmed it down to reproduce the problem with just a few lines.

Please Login or Register  to view this content.

NEXT IS THE FUNCTION CODE. That code works fine but I use it for something else, it has nothing to do with the above sub, it is in a separate module.

Please Login or Register  to view this content.

[xladept]

That's a bug in Excel - you need to set your calculation mode to manual to avoid that glitch

[jaslake]

Perhaps

Please Login or Register  to view this content.