URL Search

[Sharid]

Hi

I hope someone can help, I'm a bit stuck

At work I have a large list of url in sheet1 column A, when i click on the url a page opens up in the browser and there is another url on that page that i need, this lead to external site. I want this url to be extracted and go into column B, hopefully without the browser opening everytime as there are over 6000 url

e.g.
URL = h ttps://www.MYwebsite.com when this opens i want the URL that states https://www.Yourwebsite.com to be extracted and go in to column B

The macro then moves onto the next url, if there is more than 1 url on that page then it places it in to column C and then D and so on

Is this possible, otherwise I have to do it by hand.

 

[Sharid]

Please ignore point 2 from my last post I have managed to get the IE Browser to quite after url, I changed the code: -

From
'IE.Visible = Quit

To
IE.Quit
Set IE = Nothing

Only points 1 and 3 are the issue

 

[Sharid]

This is now cleared

The code you need is on this thread, thanks to paul for sorting the last bit out

https://www.mrexcel.com/forum/excel-questions/1040823-paste-next-blank-row-2.html