I suppose the distances between each consecutive point isn't the same, otherwise this would just be
abs(start - end)*0.8, e.g. abs(2-5)*.8 = 2.4
Besides not telling us if the distances between 2 adjacent points are the same, you haven't said if there are rows involved; i.e.
row 1A thru 1F
row 2A thru 2F
row 3A thru 3F
....
If there are no rows involved, then I must not be understanding the exact nature of the distances as my formula seems too simple.
If there are rows, then you'd need a table with a field for every horizontal point and a record for every row with a measurement for each intersection. Then you'd have to know the route a cable would take:
- direct makes the distance the hypotenuse
- over then down or vice versa makes the distance the sum
Probably what you need is a query, not vba. However, too much information missing at this point.
Last edited by Micron; 03-03-2019 at 11:50 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.