How to make a macro end on address bar change

[prescription]

Ok so it was an error on my part probably. When I pasted it I had to click fix paste error and now it works perfectly. Thank you so much you're a godsend.

Is there a specific place to learn this kind of stuff? its super cool