Check out

http://www.codeforexcelandoutlook.co...ude-functions/

and

http://processtrends.com/pg_google_e...ng%20addresses

HTH,
JP


On Jan 26, 2:29*pm, Ernie Lippert
wrote:
Given a street, city, and state address how can I find the Lattitude and
Longitude coordinates? I know I can do this for individual addresses via
Google World but I would like to program a spreadsheet macro so that I could
populate x addresses with their (Lat, Lon) coordinates.
--
Regards,
Ernie Lippert