Hi all,

I will be grateful if you can help me.

I have a macro which scrap a specific element from a website to get the distance between two postcodes.
The macro works well, however, as the macro is running through 2000+ searches.
The macro hangs at various lines in my excel worksheet, it hangs at difference points, there is no pattern to this.

I have inserted an ie.quit line and application.wait to see if that resolve the hanging. It doesn't resolve the hanging issue.

The only way I can get the macro to work completely is to end the iexplore.exe in the task manager and then I alter my macro to pick up from the last line on the excel worksheet and continue until it hangs again.

Is there a piece of code that I can use to end iexplore.exe say after every 200 or 300 lines.

Any advice or help will be appreciated as I am doing this macro for a local charity.

Thanks in advance.
Alan