Apr 18 2022 09:46 AM - edited Apr 18 2022 12:59 PM
In this sheet (it won't calculate properly in google drive) I created a LAMBDA function to add up the numbers in a string such as "5-62-85-6-2-5-259-58" and return 482. This LAMBDA function works in cell B2, and when entered in the name manager as "CALCULATOR" works as a named function in cell C2. However, when the same function is called "PARSE" in the name manager and used in cell B4, it doesn't allow it and gives a "that function isn't valid" error. I later realized that it would be more efficient to use a combination of REDUCE and TEXTSPLIT to get the results wanted, but the bug will probably creep in in other places.
Apr 18 2022 10:25 AM
SolutionWe can't use for naming Excel 4.0 Macro Functions names, they are reserved. PARSE is one of them. You may try with BEEP, OVERLAY,... - lot of them. Same result.
Apr 18 2022 10:29 AM
In addition, you may find complete list of such functions here Excel 4.0 Macro Functions • My Online Training Hub
Apr 18 2022 12:54 PM
Apr 18 2022 01:41 PM
@Eppes_A_Yungeman , you are welcome.
Sorry, that's not my intellectual property. Not necessary to provide your main address, you may create any new one.
Apr 26 2022 07:31 AM
Apr 26 2022 08:53 AM
Name Manager was done in previous century, it has many things to be updated. Perhaps one day we will have new modern one. Afraid these are global changes.
That is not only for lambdas, for any function we generate (e.g. with VBA). Perhaps Advanced Formula Environment add-in will work with reserved names when in production. Not now.
Plus cross-platforming. We may use reserved names in Excel for web, but it gives an error if we open such file in desktop version.
Hope Microsoft will solve that one day, but that's not easy task from my point of view.
Apr 18 2022 10:25 AM
SolutionWe can't use for naming Excel 4.0 Macro Functions names, they are reserved. PARSE is one of them. You may try with BEEP, OVERLAY,... - lot of them. Same result.