Insert first image into found on a search engine based on a keyword

Im trying to find a script that inserts the first image based on a keyword i.e. A1 "Abelia chinensis Variegata" finds a picture of the plant and puts it in B1

i have found the script below taken from a previous thread https://www.excelforum.com/excel-pro...from-cell.html

but i get

Althought the keyword is column D the results in A are almost all zeros

So unable to check if this does what i need it to.

Any help would be greatly appreciated.

Althought the keyword is column D the results in A are almost all zeros

So unable to check if this does what i need it to.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

Here's the thread you wanted to link to: https://www.excelforum.com/excel-pro...from-cell.html

I don't know why you sent me a PM with your code, but I have pasted it inot your post.

IMPORTANT: Update your forum proflie. 10 is NOT an Excel version.