I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.

I could copy & paste one at a time … but in some cases it would be onerous!

Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE:

The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image).

Am I missing something?

Thanks!

​I haven’t found any guidance here or elsewhere on copying existing LAMBDA functions from a workbook into a module in AFE so that I can export it into a GitHub Gist for reuse in other workbooks.I could copy & paste one at a time … but in some cases it would be onerous! Situation: I have a few workbooks with several LAMBDA functions defined as “Names”. I can bring up the list in AFE: The “duplicate” button creates the copy only in the workbook with no option to move it to a module. I can “paste” the definitions in “Formulas>Use In Formula>Paste Names” from the menu and paste them into the module text, but then lose the comments (“Creates string with…” in the image). Am I missing something? Thanks!  Read More

​