Hi everyone, really need help right here.
i've try and make some alteration of the coding to calculate the distance between latitude and longitude from http://www.cpearson.com/excel/latlong.htm with the help from other excel forum user. The coding is as below :
However, when i try to run the macro, it turn to have
compile error:
Argument not optional
i think it because of the
Cells(i, 5) = GreatCircleDistance(Lat1, long1, Lat2, long2)
does not declare all argument from the GreatCicrcleDistance function. but when i put all the arguments to the equation, nothing is happen.
Actually how to apply the function so it can be use in the excel sheet.?
Thank you very much in advance.
Bookmarks