how can i calculate distances in mass for about 7000 records through entering postcodes!

Need a small step by step guide, like what to download, what codes to put in (and where to put them in) and what formulas to use, all help will be much appreciated!!

If i understand you properly, then try to paste the below codes in the macro by pressing the window (Alt F8).

Code:

---

for a = 2 to 51
cells(a,1) = 56000 + a - 1
cells(1,a) = 56000 + a -1
next a

---

After that run the macro.