Hi all,

This code looks like exactly what I need as well but when I run it, I get the Invalid procedure call or argument error.

I've researched the error and it suggests that maybe I haven't selected the input range but I do so I'm confused.

What I'm doing exactly is selecting a range of URL's that I've entered and then going into the vba code and hitting the 'run' button.

That's when I get the error.

What am I doing wrong?

Any help would be much appreciated.

Thanks!