CALLER

Macro Sheets Only

Returns information about the cell, range of cells, command on a menu, tool on a toolbar, or object that called the macro that is currently running. Use CALLER in a subroutine or custom function whose behavior depends on the location, size, name, or other attribute of the caller.

Syntax

CALLER( )

Remarks

• If the custom function is entered in a single cell, CALLER returns the reference of that cell.
• If the custom function was part of an array formula entered in a range of cells, CALLER returns the reference of the range.
• If CALLER appears in a macro called by an Auto_Open, Auto_Close, Auto_Activate, or Auto_Deactivate macro, it returns the name of the calling sheet.
• If CALLER appears in a macro called by a command on a menu, it returns a horizontal array of three elements including the command's position number, the menu number, and the menu bar number.
• If CALLER appears in a macro called by an assigned-to-object macro, it returns the object identifier.
• If CALLER appears in a macro called by a tool on a toolbar, it returns a horizontal array containing the position number and the toolbar name.
• If CALLER appears in a macro called by an ON.DOUBLECLICK or ON.ENTRY function, CALLER returns the name of the chart object identifier or cell reference, if applicable, to which the ON.DOUBLECLICK or ON.ENTRY macro applies.
• If CALLER appears in a macro that was run manually, or for any reason not described above, it returns the #REF! error value.

Examples

If the custom function MACROS!VALUEONE is entered in cell B3 on a sheet named SALES, the nested CALLER function returns the following values.

Nested function Returns

COLUMN(CALLER()) 2

COLUMNS(CALLER()) 1

GET.CELL(1, CALLER()) SALES!$B$3

ROW(CALLER()) 3

ROWS(CALLER()) 1

If the same custom function was entered into an array in cells B2:C3, the following values would be returned.

Nested function Returns

COLUMN(CALLER()) 2

COLUMNS(CALLER()) 2

ROW(CALLER()) 2

ROWS(CALLER()) 2

Related Functions

GET.BAR Returns the name or position number of menu bars, menus, and commands

GET.CELL Returns information about the specified cell

List of Information Functions