VBA loop finding an incorrect LastRow

Hello all,

I have got a problem where loop is finding an incorrect last row and therefor instead of inserting values in the right row it inserts into a completely different row.

VBA is meant to loop through the website links in sheet called web_links and return data from website in consecutive order inside sheet Sheet1 without leaving any gaps between the webX loops. As you can see there is data from a first link ending on row number 127 and then data from second link only starts at row number 254 third link starts at 734. So there are huge gaps in between. What am I missing on? Where the logic is not right in the code?

Please Login or Register  to view this content.

The number of data rows is different on each link. You can find link with only 5 rows and find link with over couple of hundreds of rows. I dont think this what is causing this glitch to happen.

Apologies. But anyway, links do not have a set amount of rows.

Thank you very much! Obviously variable i was not being reset after the loop has finished. Genius! Worked like a charm.

Thank for update. Haven't actually noticed that. Appreciate it.