Sorry David, but I was after examples of code to measure the distance of 2 fixed lat/long positions. i.e
Distance between Lat1:51:37:42.66 N, Lon1: 3:55:44.09 W and Lat2: 51:23:51.55 N Lon2: 1:18:3.61 W
I've used several examples of the Great Circle method (see one below)but the results are not accurate.
Sub CalcDistance_click
Dim Lat1 As Double, Long1 As Double, Lat2 As Double, Long2 As Double
Dim EarthRadius, Angle, Distance As Double
EarthRadius = 6378.167 'WGS - 84
Angle = ACos(SinD(Lat1) * SinD(Lat2) + CosD(Lat1) * CosD(Lat2) * CosD(Long2 - Long1))
Distance = EarthRadius * Angle
Return Distance
End Sub