Handling error in VBA

[YasserKhalil]

Hello everyone

When I am using this line [On Error GoTo ErrHandler] to navigate to a specific point

Please Login or Register  to view this content.

I can move into the point just once but if the error occurs again, I got an error and the code stops. How can I make the code moves the point `ErrHandler` every time the error occurs?

The question posted here too
https://eileenslounge.com/viewtopic.php?f=30&t=39437

[karedog]

Using Resume Next will jump back to next code after the code that cause error, if it is in a loop then it always back to error
handler, if VBA found an error again.

Please Login or Register  to view this content.

[karedog]

Or you can also use Resume somelabel , to jump at any line that you want, but be careful with this, you need to fix some variable (for example in the code below, we need to increment i manually, or the code will run infinitely). You see, by jumping to LBL_JumpHere: we skip the rest of code after the error occurred (skip Here3 and Here4), and jump to the beginning of loop.

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much, my tutor.
Best Regards

[karedog]

You are welcome Yasser, thanks for marking the thread as solved and rep.points given.

Regards

[YasserKhalil]

As for the second code, I tried to change a little but I encountered an error at the part of ErrHandler

Please Login or Register  to view this content.

[karedog]

You are right, because we increment i and don't check for the ubound of the array, can fixed by adding this line :

Please Login or Register  to view this content.

[karedog]

Or if there is some other code after the loop that must be run, we can make another label line after this For..Next block and jump to this point

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much.

[karedog]

You are welcome

[karedog]

You can also put the label to jump at the nearest point before the Next code line, this way the code still continue to process of the loop so we don't need to increment the variable manually. This could be useful for loop that don't use index (e.g. For Each..Next, Do..While, etc)

Well, we have many variations to do this, All Roads Lead To Rome

Please Login or Register  to view this content.