REFERENCE
U.INVOKE_AS_MACRO
Summary
Calls a function created using U.COMPILE
Syntax
=U.INVOKE_AS_MACRO(function_name, [arg_config], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg], [arg])
Parameters
| Parameter | Required | Description |
|---|---|---|
function_name |
Yes | The name of the compiled function to call |
[arg] / [config] |
No | The first argument to pass to the function or config details on how to perform the invocation |
[arg] |
No | The next argument to pass to the function (or first argument if config provided) |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
[arg] |
No | The next argument to pass to the function |
Behavior
The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.
Return Value
Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.
Examples
Notes
- Formula examples are preserved from maintained workbook usage and normalized to the current
U.prefix. - Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
- Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
- For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.
Related
- Concept: Compiled and Invoked Functions
- Concept: Workbook Automation
- How-to: Run a Click-Driven Script