Legacy EVALUATE in LAMBDA: Build/Test LAMBDAs from Sheet

tboulden 

So far my focus on the development of Lambda functions is to write VBA to upload a formula (a working formula or as text) to the refers to box of the associated name.  I had wondered whether your 'unpacked let' could to run through EVALUATE to test it but it seems size might be a problem. 

I played with the naming of your function. 'λ' was one choice, and gets points for being succinct, but the option that surprised me was to name it 'EVALUATE'.  On the spreadsheet, the defined name took precedence over an illegal function but within the Lambda function it calls the XLM function.  The result is that, to all intents and purposes, EVALUATE is now a valid worksheet function!  Maybe Lambda will allow a few other legacy functions to be rehabilitated.

I will give some thought to the documentation idea.  In the past, there were occasions when I wrote the documentation in the form of comments first, and only then filled in the gaps with code.