What distance do you want to measure? Driving distance? Great circle
distance? I have a workbook on my web site that lists the latitude and
longitude of about 1200 cities in the US and it has code and formulas for
calculating the great circle distance (shortest distance) between two
cities. See http://www.cpearson.com/Excel/latlong.htm for details and
download the workbook at http://www.cpearson.com/Zips/LATITU~1.ZIP .


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)




"Ewing25" wrote in message
...
Is there anyway to find the miles between the 2 places that are inputted
into
2 different cells?

for instince if Los Angelas, CA is inputted into cell 1A and New York, NY
is
inputted into cell 1B it will automatically put into cell 1C the miles
between them.

Is there anyway to do this?

Thanks