Find the distance between locations using Google Maps?

Well, this code (function) is based on a data structure created within a workbook.
The data is stored in a named range called urlForDistance
The function returns 2 element array (vector) containing distance and time.
This result in a full code (you have shown just one, most important function) is used in some other function or procedure to show the result.

But you wrote just "another site" :-( not giving it's name or link to it. So I'll not analyze it further, but with 3 small changes I'll make an UDF returning a number out of it (you could say it's 4 changes, but change 1a could be ommitted - it just ensures recalculation).

UDF can be used as any built in function, so if you have say Brisbane in A1 and Adelaide in B1 in C1 you could write:

Formula:

Please Login or Register  to view this content.

The code is:

Please Login or Register  to view this content.

PS. As you can see in change2 I made it "Australia specific" and limited just to city centers.

Hi,
Have you tried to download and analyze VBA code in a file available at that page (download button near the bottom of the main content)?
It works exactly as I described.

The error you are getting is probably because of exceeded limit of free API calls (you may use shared IP assigned by your ISP, etc. so not necessary it was you in person who used the free API).

You may try to show this changing function definition to:

Please Login or Register  to view this content.

and then add check for the exceeded free API access flag in the code:

Please Login or Register  to view this content.

If the situation repeats (may be try using other internet connection - may be via mobile network etc.) , you may consider using API key (but I suspect it's no longer free - you probably have to pay some subscription fee to google).