Populate Address From Google Search

Hi everyone,

I'm trying to find some VBA code that will help me populate an address from a list of company names.

In Column A I have all of the company names
In Column B I would like the address to be returned.

Some additional information, all of the addresses should be in TX. I also have my google API key ready to go. I've found some really old posts about accomplishing this in other forums but the results aren't working for me. Specifically this one. Https://stackoverflow.com/questions/...cel-using-exce

Thanks for reading.

I'll give it a try. Haven't worked with Google APIs (don't give that look ��)