VBA Excel Google map distances… fill a list?

1 Star2 Stars3 Stars4 Stars5 Stars (6 votes, average: 4.83 out of 5)
Loading...
Go back to All Questions Login or Register
407 views
0

Hi,

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 :)

Thank you

Regards
Jakub

Simply the best place to learn VBA!