Return first search result from Google

Hi,

I'm using the following code to return the first search result from Google and it seems to work quite well. Although, I sometimes encounter a run-time error '91' (Object variable or With block variable not set) when running the code. When I then search the URL in google, no search results show up. Is there a way of skipping that row in VBA if no search results pop up?

Please Login or Register  to view this content.

Thanks

Hi !

It depends on the codeline where errors occurs : you must test if object exists !

Hi Marc,

So the error occurs on this line:

Please Login or Register  to view this content.

Then when I do a search for that link on google, no search results appear. I was wondering if there was a way of just skipping that row altogether and moving onto the next

Check if objH3 variable is not equal to Nothing in Locals window and if not, so there is no element "A" …

As I can't test on my side without a cell value for the URL …

Thanks Marc.

I've modified my code and it seems to work now.

Please Login or Register  to view this content.

Nice !

Thanks for the rep' !

i get a not defined error on this:"Public Sub InsertPicturesFromWeb()" anyway to fix it? new to this game. ty