UK post code calculator

This may help i created it a few months back, it uses the internet to get the distances:

open it up then right click and select distance from the bottom

Hi Mate figured it out buddy, you loop through the cells in A and pass the values into the data query then write the results back here you go:

oh yeah you may want to put the following in at the top of the sub routine:

Please Login or Register  to view this content.

Otherwise if the user enters and invalid POstcode it will debug.

if i were you i'm write in a rountine after to count the nil returns and advise the user to check the postcodes.

Cheers

brilliant that works!!..

One last questions, some of my post codes wont work and for some distances I only have town to town, probably not recognised by the internet calculator...

so is there a way of doing just what you have done but for distance between towns in the uk?

if not, no worries, appreciate your quick help on this matter

Thanks again

Hmmm,

i'm not sure only think i can think of is forcing the postcode values to change?

for example IF LS45 is creatig an error try forcing it to LS1 etc?

and anyway how do you know which of the two is incorrect to bein with?

Hope that helps

Cheers

there you go then alter the second value to the postcode below it or above it i.e. LS45 error so try LS44 and so on