LAMBDA Examples: Distance between two cities

Sameer_Bhide 

Given a named formula MyFunc in Book1, we should be able to call it from another workbook (as with vba functions):

=Book1!MyFunc(123)

If MyFunc =LAMBDA(x,x) this returns an error on my build but I assume it will work soon. Instead we could test with MyFunc = MyVBAFunc where

Function MyVBAFunc(x): MyVBAFunc = x: End Function

To access MyFunc as an add-in function without the Book1! prefix we would need to press Ctrl+F11 to open a macro sheet and change the definition in the define name dialog to a function. Or equivalently from vba:

Names("MyFunc").MacroType=xlFunction

For a simple test define the name MyFunc:=123 as a function and set the workbook IsAddin property to True. This name is then accessible from any workbook.