Prevent sub from running if next active cell is in the same row

[lanser]

As the title says I've googled and come up with the below but get an Object Require 424 error

Please Login or Register  to view this content.

I expect its something simple but I can't puzzle it out

John

[Kaper]

you declared

Please Login or Register  to view this content.

in Worksheet_Change procedure.
So it's visible only inside this procedure
not outside (for instance not in test).

You could have in worksheet code:

Please Login or Register  to view this content.

and in standard module:

Please Login or Register  to view this content.