HomeTroubleshooting@RISK for Excel: Other Issues"Error calling the macro ..."

8.30. "Error calling the macro ..."

Applies to:
@RISK, all releases
Evolver, all releases

On the Macros tab of my model settings, I list one or more macros to be called during a simulation or optimization. But I get this popup after I click Start:

Error calling the macro "..."

I've checked carefully, and the macro name is spelled correctly in the settings dialog. What is wrong?

This is probably a matter of scoping in Excel.

When @RISK calls a macro by name, Excel looks for it in several places. Depending on just where you placed the macro, its name alone may not be enough for Excel to locate it. Please follow these simple rules for best results:

Only a Sub can be set to be called automatically by @RISK or Evolver, not a Function.

Last edited: 2015-12-03

This page was: Helpful | Not Helpful