I followed this post in order to return two values from a function: http://www.geeksengine.com/article/vba-function-multiple-values2.html
Here is the code I used:
Any ideas what I'm doing wrong?
This is the error I get when the code tried to call the function call:
Have adapted an array formula from a previous thread - "Need to compare Latitude & Longitude coordinates to find closest office"
The formula is in C2 and picks up Lon and Lat from A1 & A2 and locates nearest from H2:J7...