Forum Discussion
Advanced Formula Editor: converting functions Names into a module
I've written a group of complicated functions using the AFE in Excel Labs. They are stored in the Name Manager. I now realize it would have been better to write these using the Modules editor. Is there a way to export Lambdas from the list of Functions in the Names tab of the AFE, into a Module (not a vba module, a Module within AFE).
2 Replies
Here Import module from Name Manager · Issue #56 · microsoft/advanced-formula-environment author of AFE suggests some workaround. I didn't test it and that's 2 years old, but who knows...
I don't believe there's an elegant solution at the moment. You could scoop each function out of the name manager, place them in a cell (it will evaluate to a #CALC! error), and then import from grid from the Modules tab of AFE.
I used to build functions through Names | Functions but the space is very limited. Everything begins and ends in the workbook module!
