Hello,

I've gotten good at nesting formulas to the point that I need to start using UDF's.

Function Dist(XA As Double, YA As Double, XB As Double, YB As Double)
Dist = Sqr((YA - YB) ^ 2 + (XA - XB) ^ 2)
End Function

I think the function would be improved by using

Function Dist(PT1 As Range, PT2 As Range)

PT1 would contain an X,Y coordinate with PT2 containing...