VBA to calculate distance between Uk Postcodes - Urgent help

Hi all,

Iam not the best when its comes to Macro's and VBA's as I am only just starting to learn the stuff

Can anyone help me create a Macro to determine the distance between two UK Postcodes? For Example a1: L21 1LA b1: L3 9SJ c1: 5.1 miles

Any help and some sort of idiots guide would be greatly appreciated,

Thanks in advance!

Jason

Afternoon,

I have attached a sample workbook, I have looked at past similar post's and tried a couple of different Macro's, just can't seem to get it right!

Thanks
JasonPostcode distance.xls

Hi,

Have managed to put the attached macro in, but can only get it to work out distance for 1 row:

L21 1LA M2 2AS
62.7

Can anyone edit the attached macro to be set out as per my original request?

Thanks
JasonPostcode distance.xls