Module: Dynamic Ranges

LAMBDAs and Modules

"Module" is a name Microsoft uses to refer to a package of LAMBDAs. I package related LAMBDAs into modules so we can download several LAMBDAs at once. If a module includes LAMBDAs we don't need, we can delete them for Name Manager or ignore them. Each module resides in a "gist" and each gist resides on GitHub.com. 

We can download modules from GitHub directly into Excel using Advanced Formula Environment (AFE). When we AFE to download modules, AFE requests a name for the module. AFE applies the module name as a prefix to each of the module's LAMBDAs. Thus, if we provide AFE the module name BDR, we would find the LAMBDA DynamicRowsλ in Excel's Name Manager as BDR.DynamicRowsλ. Module names do two things for us. The first is we can make sure LAMBDAs download from other modules will not have the same name so long as we keep module names unique within a workbook. The second is we can use AFE to delete all of a module's LAMBDAs with one click.