Excel VBA: On Error Goto 0 Vs On Error Goto [Label]

[@rps775]

You had entered a statement above the highlighted line "On error goto London" So you have to reset the macro before running it. Otherwise the above line will never be executed.

[@nehanaik25]

correct, either you need to click on End and re-run the code OR you can right click on "On error goto Label" line -->set next statement-->run

[@dhikarahim2679]

great, thank you. i have tried it and it works. and what about if the condition is right? is there any code to ignore the message box and continue the code?

[@ajinkyaankush3648]

That error was bcoz of you hadn't ended previous working properly

[@roshansonar8100]

you have not defined London variable