Arguments passed to a macro from Calc are always Values.
- Arguments passed to macros from computations are always values.
- It is not possible to know which cells are used. For example, =PositiveSum(A3) returns cell A3 and positive values.
- To define a macro that takes arguments, include the parameters between a pair of macro definition braces similar to a macro function.
- The parameters must be valid C identifiers separated by commas and optional spaces.
Passing Arguments to macro:
- Sum doesn't know that cell A3 was used.
- Parameters are either profile simple strings or quoted strings.
- This can be passed in the standard way of inserting variables into shared and profile pools (using VPUT in dialogs and VGET in initial macros).
- This method works best for parameters passed from one dialog to another, such as machining macros.