I just purchased your example of “EXCEL VBA CALCULATE DISTANCE BETWEEN TWO ADDRESSES OR COORDINATES”
It works great, but I would need to modify that a bit.
I have excel sheet, where there are 300 different address and I need to fill distance from single position to each of them.
So, for example:
Columns A (direction FROM), B (direction TO) and C (distance between A-B)
Values can be address or GPS – no matter.
And I thought I could “bend” your script somehow to make the calculation for all rows…
But I am too weak in VBA :(
Can you help? Need not to be for free :)