Change coding to run across multiple rows

Hello,

I currently have the following coding for a set of data on an excel spreadsheet:

Please Login or Register  to view this content.

At present this only works on one row, based on the URL in cell G2. What I want this code to do is run for all of the URLs in column G (G2,G3,G4 etc) and return the required results in the cells specified in the code (K2, K3, K4 etc and M2, M3, M4 etc).

At present this works perfectly for the one row, but I am struggling to change it so I can do it for multiple rows.

Any help is much appreciated.

Hi Marvin,

Many thanks for your response.

I am afraid that didnt work. I have noticed there is nothing in the coding regarding column K and that part of the scrape into that cell...

Still struggling with the code on this one. Anyone able to help?