Run-time error '91' - Object variable or With block not set // getting HTML elements of we

Hello every one,

I have a very strange problem with my code. I in my 1st Excel sheet a list of links and a function that loops through those links and sends them to another function that lists the HTML content on my second sheet.

function sheet 1:

Please Login or Register  to view this content.

function sheet 2:

Please Login or Register  to view this content.

Now to my specific problem.

When I run the code I have a Run-time error '91' - Object variable or With block not set error which appears randomly and I don't know where it comes from. But what is really strange is that if y set a Breakpoint and run the whole program step by step no Run-Time error appears and all goes well.

Does anyone have an idea why? Thank you in advance.

Do you have several reverences set?
Normally I open the IE like :

Please Login or Register  to view this content.

Maybe its easier when you provide an example workbook.

Thanks for the quick reply Gerard

Well I checked it on the internet as I have never used html those functions in VBA before but if your version is working I'm fine with it.
Here is my workbook with test links and stuff. Maybe the error is just coming from me.

Thank you Gerard, indeed your solution works fine.

I hate not to know why it brings us this error makes me crazy.
Anyway Thank you again for your help Gerard.

Your welcome
If problem is solved set tread [Solved] and if you like the answer grand it a *Add reputation......

Done thank you