Error handling for error that occurs frequently

Hi Experts,

I wonder since yesterday, whether there is a way to handle error that occurs many times.

For example the following code go into error handling when first time a number is divided with 0, the other nine time it throws vba run time error. Is there a way that the code go into error handler the other nine time also ?

PHP Code: 


sub test()

dim i as integer

on error goto myerror

for i = 1 to 10

debug.print i/0

next i

myerror:

msgbox "You tried to divide by zero"

end sub 


Hi,
I don't understand your question. as it is now it there will be just one error - the first time, after that it will go to the error handler and show msg. after that sub will end. There will be no nine more errors

I agree w/ Buran, but you should have an Exit Sub after the Next i.

Please change your PHP tags to CODE tags.

Please Login or Register  to view this content.