Hi

I've created a spreadsheet with a series of postcodes down one side which I want to be able to calculate the distances between them. However, when I use the function it always comes back with a 0. After checking using a few well placed msgbox's, I've found it's coming back with NOT FOUND. However, I place the URL into Explorer the route appears fine.

Any ideas?

I refer back : http://www.excelforum.com/excel-gene...g-times-3.html