Announcing LAMBDA: Turn Excel formulas into custom functions

Happiness.  LAMBDA has arrived!  OK, so I accept that is a somewhat geeky viewpoint.

I understand that the function is now released to 100% of beta channel users.

Just in case it helps, I wrote the following macro to load Names from the worksheet.

Sub CreateName()
Dim NameString As String
Dim RefersTo As String
Dim selectedNames
Dim cell As Range

If Not Intersect([defined.names], Selection) Is Nothing Then
    Set selectedNames = Intersect([defined.names], Selection)
    For Each cell In selectedNames
        NameString = cell.Value
        On Error Resume Next
        ActiveSheet.Names(NameString).Delete
        On Error GoTo 0
    Next
    For Each cell In selectedNames
        NameString = cell.Value
        RefersTo = cell.Offset(0, 1).Formula
        On Error GoTo fail
        ActiveSheet.Names.Add NameString, RefersTo
        MsgBox "Name " & NameString & " set to refer to: " & RefersTo
    Next
End If
Exit Sub

fail: MsgBox "Failed to set " & NameString
End Sub

The Names are held in the range 'defined.names' and the formula is held in the cell to the right, either as a working formula or using the apostrophe to reduce it to a string.  The macro is run by selecting the names to upload and using the 'onAction' property (assign macro) of a shape to run it.  The formula is better for development and the string form for reference.

My VBA skills are not the greatest, so feel free to improve the macro if you so choose.