@Charles_Exceller Maybe I was unclear. I was not saying you have to do
anything as a user. I was just suggesting using the hook into the
existing internal mechanism for letting Excel know what functions exist,
and information about them (as displayed in the Function Wizard). This
could happen behind...
@DS_London I personally think that this move to LAMBDAs is a way to move
away from VBA. I also work in cybersecurity, and macros are an enemies,
not friends... They are more and more blocked in organizations.If you
have to register a LAMBDA like any other add-in, you're not on the
correct path. Why ...
@Peter Bartholomew Totally agree ... "Both LET and LAMBDA support the
view of Excel as a programming platform rather than an interactive
WYSIWYG environment for the direct manipulation of numbers. A major
upgrade to Name Manager and Evaluate Formula is needed to support LAMBDA
and any change can onl...
I've been reading the other comments and thoughts on this, and the 80/20
rule is coming to mind (or perhaps 95/5).LAMBDAs, and to some extent
LET, fill the gap between using existing Excel formulas (and some
spreadsheet real-estate) and creating full-blown UDFs using an add-in
methodology (vba modul...
@Sergei Baklan Sergei<I only hope one day lambda will go out from name
manager umbrella>I see where you are coming from but I would put it the
other way round. Name Manager never has been fit for purpose as an
environment for developing Names. It is just sufficient if one restricts
the idea of Names...
Latest Comments