on error doesn't work

[ilkamalo]

when i disable internet connection to try the error procedure instead of doing the line related to the error the macro show a message error ; can someone tell where the error is thanks .i've added 2 attachments too to see what happens when i push F8.

Please Login or Register  to view this content.

[shg]

Error handling should be structured like this:

Please Login or Register  to view this content.

[ilkamalo]

thank for your help ; but there is still some problem when there is no connection it enter Etichetta1:
and give me the same error ; with connection evrything is ok

Please Login or Register  to view this content.

[royUK]

You still have the On Error in the wron place, it should be before the code starts

Please Login or Register  to view this content.