Microsoft<hope now you are happy>
Yes. Yesterday was good. Received LAMBDA and a shot of the Pfizer vaccine!
<Didn't test your script, but does it give another result compare to Formulas->Use in Formula->Paste Names?>
I hope not! The script was one I had used before, for uploading Named Formulas (which were complex by the standards of the day but nothing compared with the solutions that are now emerging). It is only intended as a starting point. For the LAMBDA function it would probably be a good idea to allow function parameters in the cell but strip them out when uploading to the defined name.
<Names is the last resort>
I think we are in agreement. Name Manager does not provide a development environment; that even goes for the JKP version. I normally develop formulas on the worksheet and then upload (the process has become easier since the plague of implicit intersection has been dispensed with in the grid).
Maybe the community should specify an ideal development environment for Excel formulas; the formula bar is also no longer up to the job.
In my mind it would be a floating window, linked to a specific cell to cover the rare occasions in which relative referencing is needed. It must support formulas written over multiple lines and using normal indentation conventions. IntelliSense and the use of Tab for name completion must be available. The F3 name selection should be usable (possibly continuously displayed). It should also be possible to use formula evaluation to help identify defects within the formulation. LAMBDA and recursive formulas provide a new challenge in that regard but that may have to wait a while.
Are my ideas too limited? Would a common look and feel with other MS SDK environments (or PQ advanced editor) be of value?
