Error Trapping Problem.
I'm sure that this must be a simple one, but I can't seem to resolve it.
I have written a procedure which involves a loop. A bit of code within the loop may return an error, and so I have included an error trap.
The first time that the error occurs in the loop, the error trap is triggered as I would expect, but on subsequent occasions when the error occurs, the trap is ignored and an error message occurs.
What am I missing?
(Thanks in anticipation!)
[500 byte] By [
Laurel] at [2007-11-20 11:03:57]
# 2 Re: Error Trapping Problem.
I'm sure that this must be a simple one, but I can't seem to resolve it.
I have written a procedure which involves a loop. A bit of code within the loop may return an error, and so I have included an error trap.
The first time that the error occurs in the loop, the error trap is triggered as I would expect, but on subsequent occasions when the error occurs, the trap is ignored and an error message occurs.
What am I missing?
(Thanks in anticipation!)
after each error message you could use Err.Clear
# 3 Re: Error Trapping Problem.
Thanks very much both of you for your replies.
I've just realised that I was missing a 'resume' statement after the error-trap.
A simple (but fatal) mistake. :)
Laurel at 2007-11-9 19:36:02 >
