I want to calculate distance between two latitude and longitude coordinate.

The macro 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.?

Btw, i've attached the xsl file together in this thread.
Please take a look on it.
Thank you very much.