I'm trying to design a macro that can be run for many cells that will go out to the web to run a search and paste the results in the relevant adjacent cell. Instead of the results showing up on a message box, how do I write this? I'm very new to this so please excuse me if I sound like I haven't a clue.

Here's my script:

Please Login or Register  to view this content.
Here's how I want the results to look like:

image001.jpg

Let me know if you have any questions, I look forward to your help! -Eric