Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I'm discovering an odd problem ...
As I am stepping through my code, when I reach a particular line in a procedure, it suddenly jumps out of the procedure and goes back to the 'next' of the loop from which that procedure was called.
I am inclined to think that if there is an error with the line, it leaves the procedure.
I am relatively new to Excel VBA, so I can't begin to imagine why this behaviour exists. Could it have something to do with "on error resume next"? code? I don't use it very often (only a small handful of instances in my project) I know I don't have it in the procedure that is being exited, so unsure how, if at all, this may be part f it.
Any help would be greatly appreciated.
As I am stepping through my code, when I reach a particular line in a procedure, it suddenly jumps out of the procedure and goes back to the 'next' of the loop from which that procedure was called.
I am inclined to think that if there is an error with the line, it leaves the procedure.
I am relatively new to Excel VBA, so I can't begin to imagine why this behaviour exists. Could it have something to do with "on error resume next"? code? I don't use it very often (only a small handful of instances in my project) I know I don't have it in the procedure that is being exited, so unsure how, if at all, this may be part f it.
Any help would be greatly appreciated.