CALL Function Explained
The CALL function in Microsoft Excel allows users to run a macro from within a worksheet. It takes two arguments: the name of the macro to be run and an optional reference to a cell containing the macro. The CALL function is useful for running macros that are stored in a different worksheet or workbook.
CALL Function Syntax
CALL(module_text, procedure, argument1, [argument2], ...)
- module_text: The name of the dynamic link library (DLL) or code resource containing the procedure to be called.
- procedure: The name of the procedure to be called.
- argument1: The first argument to be passed to the procedure.
- argument2: [Optional] The second argument to be passed to the procedure.
- …: [Optional] Additional arguments to be passed to the procedure.