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 the...
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!