RUN

Macro Sheets Only

Equivalent to choosing the Run button in the Macro dialog box, which appears when you choose the Macro command from the Tools menu. Runs a macro.

Syntax

RUN(reference, step)
RUN?(reference, step)

Reference is a reference to the macro you want to run or a number from 1 to 4 specifying an Auto macro to run.

If reference is Specifies

1 All Auto_Open macros on the active workbook

2 All Auto_Close macros

3 All Auto_Activate macros

4 All Auto_Deactivate macros

• If reference is a range of cells, RUN begins with the macro function in the upper-left cell of reference.
• If the macro sheet containing the macro is not the active document, reference can be an external reference to the name of the macro, such as RUN([BOOK1]Macro!Months) or an external R1C1-style reference to the location of the macro, such as RUN("[Book1]Macro!R2C3"). The reference must be in text form.
• If reference is omitted, the macro function in the active cell is carried out, and macro execution continues down that column.

Step is a logical value specifying that the macro is to be run in single-step mode. If step is TRUE, Microsoft Excel runs the macro in single-step mode; if FALSE or omitted, Microsoft Excel runs the macro normally.

Remarks

• RUN is recorded when you choose the Run command from the Macro menu while recording a macro. The reference you enter in the Run dialog box is recorded as text, with A1-style references converted to R1C1-style references.
• To run a macro from a macro sheet, you could alternatively enter the name of the macro as a formula, followed by a set of parentheses. For example, enter =[Book1]Macro!Months() instead of =RUN([Book1]Macro!Months).

Related Functions

GOTO Directs macro execution to another cell

List of Command-Equivalent Functions