How to get this code to update for new sites?

Hi all!

So I have this code that I picked from a tutorial and edited it to what I needed. My final goal is to have a spreadsheet which will have several sites for which this code will get the weather forecast for which the refresh button will update all simultaneously. I need help on how to loop the refresh, I pretty much understand how to get the other address for the sites but no idea how to loop it so it adds/updates more places in the spreadsheet. Any help is appreciated.

Please Login or Register  to view this content.

Thank you so much protonLeah! That worked great! I'm going to study it and see what I can get out of it. This will definitely help me with my VBA.

If I wanted to get the from and to, latitude and longitude and temperature value and arrange it per column from a code that looks like so:

HTML Code: 

what would I have to change in my VBA? This is coming from this API
http://api.yr.no/weatherapi/location...on=-95.3324395

I tried giving it a go but it wont work. I am assuming it is because the values are inside the tags I also changed the cell() so that the counter Col would add the values downwards instead of to the right. Any input is very appreciated! I think once this is set up I will be done!