Find Url If Missing Move On

[timbo1957]

Hi,

One of the forum members gave me this piece of code to run down column A starting at A2 on a sheet called urls. It goes to the relevant url copies the data adds a sheet and pastes the data into it.

Works perfectly with one small exception if the url has been removed then it can't find anything and it stops at -

Please Login or Register  to view this content.

Could anyone give me a piece of code to add so that of the url isn't found it moves onto the next? i.e. if the url in a33 can't be found it moves to a34 and so on.

Many thanks.

Please Login or Register  to view this content.