| Macro | Description |
|---|---|
| A1.R1C1 | Displays row and column headings and cell references in either the R1C1 or A1 reference style |
| ABSREF | Returns the absolute reference of the cells that are offset from a reference by a specified amount |
| ACTIVATE | Switches to a window if more than one window is open, or a pane of a window if the window is split and its panes are not frozen |
| ACTIVATE.NEXT ACTIVATE.PREV | Switches to the next or previous window, respectively, or switches to the next or previous sheet in a workbook |
| ACTIVE.CELL | Returns the reference of the active cell in the selection as an external reference |
| ACTIVE.CELL.FONT | Equivalent to formatting individual characters in a cell |
| ADD.ARROW | Equivalent to clicking the Arrow button on the Drawing toolbar |
| ADD.BAR | Creates a new menu bar and returns the bar ID number |
| ADD.CHART.AUTOFORMAT | Adds the format of the currently active chart in the current window to the list of custom formats in the Custom Types tab in the Chart Type dialog box |
| ADD.COMMAND | Adds a command to a menu |
| ADDIN.MANAGER | Equivalent to clicking the Add-Ins command on the Tools menu |
| ADD.LIST.ITEM | Adds an item in a list box or drop-down control on a worksheet or dialog sheet control |
| ADD.MENU | Adds a menu to a menu bar |
| ADD.OVERLAY | Equivalent to clicking the Add Overlay command on the Chart menu in Microsoft Excel version 4 |
| ADD.TOOL | Adds one or more buttons to a toolbar |
| ADD.TOOLBAR | Creates a new toolbar with the specified buttons |
| ALERT | Displays a dialog box and message and waits for you to click a button |
| ALIGNMENT | Equivalent to clicking the Alignment tab in the Format Cells dialog box, which is displayed when you click the Cells command on the Format menu |
| ANOVA1 | Performs single-factor analysis of variance, which tests the hypothesis that means from several samples are equal |
| ANOVA2 | Performs two-factor analysis of variance with replication |
| ANOVA3 | Performs two-factor analysis of variance without replication |
| APP.ACTIVATE | Switches to an application |
| APP.ACTIVATE.MICROSOFT | Activates a Microsoft application |
| APPLY.NAMES | Equivalent to clicking the Apply command on the Name submenu on the Insert menu |
| APPLY.STYLE | Equivalent to clicking the Style command on the Format menu, selecting a style, and clicking the OK button |
| APP.MAXIMIZE | Equivalent to clicking the Maximize command on the Control menu for the application window |
| APP.MINIMIZE | Equivalent to clicking the Minimize command on the Control menu for the application window |
| APP.MOVE | Equivalent to clicking the Move command on the Control menu for the application window |
| APP.RESTORE | Equivalent to clicking the Restore command on the Control menu for the application window |
| APP.SIZE | Equivalent to choosing the Size command from the Control menu for the application window |
| APP.TITLE | Changes the title of the Microsoft Excel application workspace to the title you specify |
| ARGUMENT | Describes the arguments used in a custom function, which is a type of macro, or in a subroutine |
| ARRANGE.ALL | Equivalent to clicking the Arrange command on the Window menu |
| ASSIGN.TO.OBJECT | Assigns a macro to the currently select object |
| ASSIGN.TO.TOOL | Assigns a macro to be run when a button is clicked with the mouse |
| ATTACH.TEXT | Attaches text to certain parts of the selected chart |
| ATTACH.TOOLBARS | Displays the Attach Toolbars dialog box, which you use to attach or associate toolbars with documents |
| AUTO.OUTLINE | Equivalent to clicking the Auto Outline command on the Group And Outline submenu of the Data menu |
| AXES | Controls whether the axes on a chart are visible |
| BEEP | Sounds a tone |
| BORDER | Equivalent to clicking the Border tab in the Format Cells dialog box, which appears when you click the Cells command on the Format menu |
| BREAK | Interrupts a FOR-NEXT, a FOR |
| BRING.TO.FRONT | Puts the selected object or objects on top of all other objects |
| CALCULATE.DOCUMENT | Equivalent to choosing the Calc Sheet button in the Calculation tab on the Options dialog, which appears when you choose the Options command from the Tools menu |
| CALCULATE.NOW | Equivalent to clicking the Calculation tab in the Options dialog box and then clicking the Calc Now button |
| CALCULATION | Controls when and how formulas in open workbooks are calculated |
| CALLER | 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 |
| CANCEL.COPY | Equivalent to pressing ESC in Microsoft Excel for Windows or ESC or COMMAND+PERIOD in Microsoft Excel for the Macintosh to cancel the marquee after you copy or cut a selection |
| CANCEL.KEY | Disables macro interruption, or specifies a macro to run when a macro is interrupted |
| CELL.PROTECTION | Equivalent to choosing the Protection tab in the Format Cells dialog box, which appears when you choose the Cells command from the Format menu |
| CHANGE.LINK | Equivalent to clicking the Change Source button in the Links dialog box, which appears when you click the Links command on the Edit menu |
| CHART.ADD.DATA | Equivalent to dragging data from a worksheet onto a chart |
| CHART.TREND | A trendline can be added to only to the these chart types: bar, column, stacked column, scatter, line, and area |
| CHART.WIZARD | Equivalent to clicking the ChartWizard button on the standard or chart toolbar |
| CHECKBOX.PROPERTIES | Sets various properties of check box and option box controls on a worksheet or dialog sheet |
| CHECK.COMMAND | Adds or removes a check mark to or from a command name on a menu |
| CLEAR | Equivalent to clicking the Clear command on the Edit menu |
| CLEAR.OUTLINE | Equivalent to clicking the Clear Outline command on the Group And Outline submenu of the Data menu |
| CLEAR.ROUTING.SLIP | Equivalent to the Clear button in the Routing Slip dialog box |
| CLOSE | Closes the active window |
| CLOSE.ALL | Equivalent to clicking the Close All command on the File menu |
| COLOR.PALETTE | Copies a color palette from an open workbook to the active workbook |
| COLUMN.WIDTH | Equivalent to choosing the Width command on the Column submenu of the Format menu |
| COMBINATION | Changes the format of the active chart to one of six built-in combination chart types |
| CONSOLIDATE | Equivalent to clicking the Consolidate command on the Data menu |
| CONSTRAIN.NUMERIC | Equivalent to pressing the Constrain Numeric button |
| COPY | Equivalent to clicking the Copy command on the Edit menu |
| COPY.CHART | Equivalent to choosing the Copy Chart command from the Edit menu in Microsoft Excel for the Macintosh version 1 |
| COPY.PICTURE | Equivalent to choosing the Copy Picture command from the Edit menu |
| COPY.TOOL | Copies a button face to the Clipboard |
| CREATE.NAMES | Equivalent to clicking the Create command on the Name submenu of the Insert menu |
| CREATE.OBJECT | Draws an object on a sheet or macro sheet and returns a value identifying the object created |
| CREATE.PUBLISHER | Equivalent to clicking the Create Publisher command on the Publishing submenu of the Edit menu |
| CUSTOMIZE.TOOLBAR | Equivalent to choosing the Toolbars command from the View menu and choosing the Customize button in Microsoft Excel 95 |
| CUSTOM.REPEAT | Allows custom commands to be repeated using the Repeat tool or the Repeat command on the Edit menu |
| CUSTOM.UNDO | Creates a customized Undo tool and Undo or Redo command on the Edit menu for custom commands |
| CUT | Equivalent to choosing the Cut command from the Edit menu |
| DATA.DELETE | Equivalent to clicking the Delete command on the Data menu in Microsoft Excel version 4 |
| DATA.FIND | Equivalent to clicking the Find and Exit Find commands on the Data menu in Microsoft Excel version 4 |
| DATA.FIND.NEXT DATA.FIND.PREV | Equivalent to pressing the DOWN ARROW or UP ARROW key after the Find command has been chosen from the Data menu in Microsoft Excel version 4 |
| DATA.FORM | Equivalent to clicking the Form command on the Data menu |
| DATA.LABEL | Specifies label contents and position |
| DATA.SERIES | Equivalent to clicking the Series command on the Fill submenu of the Edit menu |
| DEFINE.NAME | Equivalent to clicking the Define command on the Name submenu of the Insert menu |
| DEFINE.STYLE | Equivalent to clicking the Define button in the Style dialog box, which appears when you click the Style command on the Format menu |
| DELETE.ARROW | Deletes the selected arrow, either drawn as an arrow with the arrow tool or as a line that is later formatted as an arrow |
| DELETE.BAR | Deletes a custom menu bar |
| DELETE.CHART.AUTOFORMAT | Deletes a custom format from the list of formats shown in the Custom Types tab in the Chart Type dialog box |
| DELETE.COMMAND | Deletes a command from a custom or built-in menu |
| DELETE.FORMAT | Equivalent to deleting the specified format in the Number tab in the Format Cells dialog box, which appears when you click the Cells command on the Format menu, or in the Number tab for selected chart objects |
| DELETE.MENU | Deletes a menu or submenu |
| DELETE.NAME | Equivalent to clicking the Delete button in the Define Name dialog box, which appears when you click the Define command on the Name submenu of the Insert menu |
| DELETE.OVERLAY | Equivalent to clicking the Delete Overlay command on the Chart menu in Microsoft Excel version 4 |
| DELETE.STYLE | Equivalent to choosing the Delete button from the Style dialog box, which appears when you choose the Style command from the Format menu |
| DELETE.TOOL | Equivalent to selecting a button and dragging it to an area other than a toolbar |
| DELETE.TOOLBAR | Equivalent to clicking the Delete button in the Toolbars dialog box, which appears when you click the Customize command (View menu, Toolbars submenu) |
| DEMOTE | Equivalent to clicking the Group tool |
| DEREF | Returns the value of the cells in a reference |
| DESCR | Generates descriptive statistics for data in the input range |
| DIALOG.BOX | Displays the dialog box described in a dialog box definition table |
| DIRECTORY | Sets the current drive and directory or folder to the specified path and returns the name of the new directory or folder as text |
| DISABLE.INPUT | Blocks all input from the keyboard and mouse to Microsoft Excel (except input to displayed dialog boxes) |
| DISPLAY | Controls whether the screen displays formulas, gridlines, row and column headings, and other screen attributes |
| DOCUMENTS | Returns, as a horizontal array in text form, the names of the specified open workbooks |
| DUPLICATE | Duplicates the selected object |
| ECHO | Controls screen updating while a macro is running |
| EDITBOX.PROPERTIES | Sets the properties of an edit box on a dialog sheet |
| EDIT.COLOR | Equivalent to clicking the Modify button on the Color tab, which appears when you click the Options command on the Tools menu |
| EDIT.DELETE | Equivalent to clicking the Delete command on the Edit menu |
| EDITION.OPTIONS | Sets options in, or performs actions on, the specified publisher or subscriber |
| EDIT.OBJECT | Equivalent to clicking the Edit command on the (selected object) Object submenu of the Edit menu |
| EDIT.REPEAT | Equivalent to clicking the Repeat command on the Edit menu |
| EDIT.SERIES | Equivalent to clicking the Edit Series command on the Chart menu in Microsoft Excel version 4 |
| EDIT.TOOL | Displays the Button Editor dialog box, which you use to change the appearance of a button on a toolbar |
| ELSE | Used with IF, ELSE |
| ELSE.IF | Used with IF, ELSE, and END |
| EMBED | Displayed in the formula bar when an embedded object is selected |
| ENABLE.COMMAND | Enables or disables a custom command or menu |
| ENABLE.OBJECT | Enables or disables a drawing object or the selected drawing object |
| ENABLE.TIPWIZARD | This function should not be used |
| ENABLE.TOOL | Enables or disables a button on a toolbar |
| END.IF | Ends a block of functions associated with the preceding IF function |
| ENTER.DATA | Turns on Data Entry mode and allows you to select and to enter data into the unlocked cells in the current selection only (the data entry area) |
| ERROR | Specifies what action to take if an error is encountered while a macro is running |
| ERRORBAR.X ERRORBAR.Y | Adds error bars to the selected series in a chart |
| EVALUATE | Evaluates a formula or expression that is in the form of text and returns the result |
| EXEC | Starts a separate program |
| EXECUTE | Carries out commands in another program with which you have a dynamic data exchange (DDE) link |
| EXPON | Predicts a value based on the forecast for the prior period, adjusted for the error in that prior forecast |
| EXTEND.POLYGON | Adds vertices to a polygon |
| EXTRACT | Equivalent to choosing the Extract command from the Data menu in Microsoft Excel version 4 |
| FCLOSE | Closes the specified file |
| FILE.CLOSE | Equivalent to clicking the Close command on the File menu |
| FILE.DELETE | Deletes a file from the disk |
| FILES | Returns a horizontal text array of the names of all files in the specified directory or folder |
| FILL.AUTO | Equivalent to copying cells or automatically filling a selection by dragging the fill selection handle with the mouse (the AutoFill feature) |
| FILL.DOWN FILL.LEFT FILL.RIGHT FILL.UP | Equivalent to clicking the Down, Left, Right, and Up commands, respectively, on the Fill submenu of the Edit menu |
| FILL.GROUP | Equivalent to choosing the Across Worksheets command from the Fill submenu on the Edit menu |
| FILTER | Filters lists of data one column at a time |
| FILTER.ADVANCED | Equivalent to choosing the Advanced Filter command from the Filter submenu on the Data menu |
| FILTER.SHOW.ALL | Equivalent to choosing the Show All command from the Filter submenu on the Data menu |
| FIND.FILE | Equivalent to choosing the Find File command from the File menu in Microsoft Excel version 5 |
| FONT | Equivalent to clicking the Font command on the Options menu in Microsoft Excel for the Macintosh version 1 |
| FONT.PROPERTIES | Equivalent to choosing the Cells command from the Format menu |
| FOPEN | Opens a file with the type of permission specified |
| FOR | Starts a FOR-NEXT loop |
| FOR.CELL | Starts a FOR |
| FORMAT.AUTO | Equivalent to clicking the AutoFormat command on the Format menu when a worksheet is active or clicking the AutoFormat button |
| FORMAT.CHART | Equivalent to choosing the Options button in the Chart Type dialog box, which is available when you choose the Chart Type command from the Format menu when a chart is active |
| FORMAT.CHARTTYPE | Changes the chart type for a selected data series, a group of data series, or an entire chart |
| FORMAT.FONT | Equivalent to choosing the Cells command from the Format menu, and then selecting Font tab from the Format Cells dialog box |
| FORMAT.LEGEND | Equivalent to clicking the Selected Legend command on the Format menu when a chart is active |
| FORMAT.MAIN | Equivalent to clicking the Main Chart command on the Format menu in Microsoft Excel version 4 |
| FORMAT.MOVE | Equivalent to moving an object with the mouse |
| FORMAT.NUMBER | Equivalent to choosing the Number tab in the Format Cells dialog box, which appears when you choose Cells from the Format menu |
| FORMAT.OVERLAY | Equivalent to clicking the Overlay command on the Format menu in Microsoft Excel version 4 |
| FORMAT.SHAPE | Equivalent to clicking the reshape button on the Drawing toolbar and then inserting, moving, or deleting vertices of the selected polygon |
| FORMAT.SIZE | Equivalent to sizing an object with the mouse |
| FORMAT.TEXT | Formats the selected worksheet text box or button or any text item on a chart |
| FORMULA | Enters a formula in the active cell or in a reference |
| FORMULA.ARRAY | Enters a formula as an array formula in the range specified or in the current selection |
| FORMULA.CONVERT | Changes the style and type of references in a formula between A1 and R1C1 and between relative and absolute |
| FORMULA.FILL | Enters a formula in the range specified or in the current selection |
| FORMULA.FIND | Equivalent to clicking the Find command on the Edit menu |
| FORMULA.FIND.NEXT FORMULA.FIND.PREV | Finds the next and previous cells on the worksheet, as specified in the Find dialog box, and returns TRUE |
| FORMULA.GOTO | Equivalent to clicking the Go To command on the Edit menu or to pressing F5 |
| FORMULA.REPLACE | Equivalent to clicking the Replace command on the Edit menu |
| FOURIER | Performs a Fourier transform |
| FPOS | Sets the position of a file |
| FREAD | Reads characters from a file, starting at the current position in the file |
| FREADLN | Reads characters from a file, starting at the current position in the file and continuing to the end of the line, placing the characters in the cell containing FREADLN |
| FREEZE.PANES | Equivalent to clicking the Freeze Panes or Unfreeze Panes command on the Window menu |
| FSIZE | Returns the number of bytes in a file |
| FTESTV | Performs a two-sample F-test |
| FULL | Equivalent to pressing CTRL+F10 (full size) and CTRL+F5 (previous size) or double-clicking the title bar in Microsoft Excel for Windows version 3 |
| FULL.SCREEN | Equivalent to clicking the Full Screen command on the View menu |
| FUNCTION.WIZARD | Displays the Paste Function dialog box, which you can use to enter functions into cells |
| FWRITE | Writes text to a file, starting at the current position in that file |
| FWRITELN | Writes text, followed by a carriage return and linefeed, to a file, starting at the current position in that file |
| GALLERY.3D.AREA | Changes the format of the active chart to a 3-D area chart |
| GALLERY.3D.BAR | Changes the active chart to a 3-D bar chart |
| GALLERY.3D.COLUMN | Changes the format of the active chart to a 3-D column chart |
| GALLERY.3D.LINE | Changes the format of the active chart to a 3-D line chart |
| GALLERY.3D.PIE | Changes the format of the active chart to a 3-D pie chart |
| GALLERY.3D.SURFACE | Changes the active chart to a 3-D surface chart |
| GALLERY.AREA | Changes the format of the active chart to an area chart |
| GALLERY.BAR | Changes the format of the active chart to a bar chart |
| GALLERY.COLUMN | Changes the format of the active chart to a column chart |
| GALLERY.CUSTOM | Changes the format of the active chart to the custom format |
| GALLERY.DOUGHNUT | Changes the format of the active chart to a doughnut chart |
| GALLERY.LINE | Changes the format of the active chart to a line chart |
| GALLERY.PIE | Changes the format of the active chart to a pie chart |
| GALLERY.RADAR | Changes the format of the active chart to a radar chart |
| GALLERY.SCATTER | Changes the format of the active chart to an xy (scatter) chart |
| GET.BAR | Returns the number of the active menu bar |
| GET.CELL | Returns information about the formatting, location, or contents of a cell |
| GET.CHART.ITEM | Returns the vertical or horizontal position of a point on a chart item |
| GET.DEF | Returns the name, as text, that is defined for a particular area, value, or formula in a workbook |
| GET.DOCUMENT | Returns information about a sheet in a workbook |
| GET.FORMULA | Returns the contents of a cell as they would appear in the formula bar |
| GET.LINK.INFO | Returns information about the specified link |
| GET.NAME | Returns the definition of a name as it appears in the Refers To box of the Define Name dialog box, which appears when you choose the Define command from the Name submenu on the Insert menu |
| GET.NOTE | Returns characters from a comment |
| GET.OBJECT | Returns information about the specified object |
| GET.PIVOT.FIELD | Returns information about a field in a PivotTable report |
| GET.PIVOT.ITEM | Returns information about an item in a PivotTable report |
| GET.PIVOT.TABLE | Returns information about a PivotTable report |
| GET.TOOL | Returns information about a button or buttons on a toolbar |
| GET.TOOLBAR | Returns information about one toolbar or all toolbars |
| GET.WINDOW | Returns information about a window |
| GET.WORKBOOK | Returns information about a workbook |
| GET.WORKSPACE | Returns information about the workspace |
| GOAL.SEEK | Equivalent to clicking the Goal Seek command on the Tools menu |
| GOTO | Directs a macro to continue running at the upper-left cell of reference |
| GRIDLINES | Allows you to turn chart gridlines on and off |
| GROUP | Creates a single object from several selected objects and returns the object identifier of the group (for example, "Group 5") |
| HALT | Stops all macros from running |
| HELP | Starts or switches to Help and displays the specified custom Help topic |
| HIDE | Equivalent to clicking the Hide command on the Window menu |
| HIDE.DIALOG | Closes the dialog box that has the current focus |
| HIDE.OBJECT | Hides or displays the specified object |
| HISTOGRAM | Calculates individual and cumulative percentages for a range of data and a corresponding range of data bins |
| HLINE | Scrolls through the active window by a specific number of columns |
| HPAGE | Horizontally scrolls through the active window one window at a time |
| HSCROLL | Horizontally scrolls through the active sheet by percentage or by column number |
| IF | Used with ELSE, ELSE |
| INITIATE | Opens a dynamic data exchange (DDE) channel to an application and returns the number of the open channel |
| INPUT | Displays a dialog box for user input |
| INSERT | Inserts a blank cell or range of cells or pastes cells from the Clipboard into a sheet |
| INSERT.OBJECT | Equivalent to choosing the Object command from the Insert menu, and then selecting an object type and choosing the OK button |
| INSERT.PICTURE | Equivalent to clicking the Picture command on the Insert menu |
| INSERT.TITLE | Attaches text to various parts of a chart |
| JUSTIFY | Equivalent to clicking the Justify command on the Fill submenu of the Edit menu |
| LABEL.PROPERTIES | Sets the accelerator property of the label and group box controls on a worksheet or dialog sheet |
| LAST.ERROR | Returns the reference to the cell where the last macro sheet error occurred |
| LEGEND | Adds a legend to or removes a legend from a chart |
| LINE.PRINT | Prints the active worksheet using methods compatible with those of Lotus 1-2-3 |
| LINK.COMBO | Links an edit box and a list box control into a linked combination box group |
| LINK.FORMAT | Links the number format of the selected data label to the worksheet cell or range containing the data label text |
| LINKS | Returns, as a horizontal array of text values, the names of all workbooks referred to by external references in the workbook specified |
| LISTBOX.PROPERTIES | Sets the properties of a list box and drop-down controls on a worksheet or dialog sheet |
| LIST.NAMES | Equivalent to clicking the Paste command on the Name submenu of the Insert menu and selecting the Paste List option button |
| MACRO.OPTIONS | Equivalent to clicking the Options button in the Macro dialog box, which appears when you click the Macros command (Tools menu, Macro submenu) |
| MAIL.ADD.MAILER | Equivalent to clicking the Add Mailer command on the Mail submenu of the File menu |
| MAIL.DELETE.MAILER | Equivalent to clicking the Delete Mailer command on the Mail submenu of the File menu |
| MAIL.EDIT.MAILER | Equivalent to clicking the Mailer button when mailer is attached to the current workbook |
| MAIL.FORWARD | Equivalent to clicking the Forward command on the Mail submenu of the File menu |
| MAIL.LOGOFF | Ends the current mail session |
| MAIL.LOGON | Starts a mail session |
| MAIL.NEXT.LETTER | Equivalent to clicking the Next Letter command on the Mail submenu of the File menu |
| MAIL.REPLY | Equivalent to clicking the Reply command on the Mail submenu of the File menu |
| MAIL.REPLY.ALL | Equivalent to clicking the Reply All command on the Mail submenu of the File menu |
| MAIL.SEND.MAILER | Equivalent to clicking the Send Mailer command on the Mail submenu of the File menu |
| MAIN.CHART | Equivalent to clicking the Main Chart command on the Format menu when a chart sheet is active in Microsoft Excel version 2 |
| MAIN.CHART.TYPE | Equivalent to clicking the Main Chart Type command on the Chart menu in Microsoft Excel for the Macintosh version 1 |
| MCORREL | Returns a correlation matrix that measures the correlation between two or more data sets that are scaled to be independent of the unit of measurement |
| MCOVAR | Returns a covariance matrix that measures the covariance between two or more data sets |
| MENU.EDITOR | This function should not be used in Microsoft Excel 97 or later because the Menu Editor is only available in Microsoft Excel 95 and Microsoft Excel version 5 |
| MERGE.STYLES | Equivalent to clicking the Merge button in the Style dialog box, which appears when you click the Style command on the Format menu |
| MESSAGE | Displays and removes messages in the message area of the status bar |
| MOVE | Equivalent to moving a window by dragging its title bar in Microsoft Excel version 3 |
| MOVEAVG | Projects values in a forecast period, based on the average value of the variable over a specific number of preceding periods |
| MOVE.TOOL | Moves or copies a button from one toolbar to another |
| NAMES | Returns, as a horizontal array of text, the specified names defined in the specified workbook |
| NEW | Equivalent to clicking the New command on the File menu |
| NEW.WINDOW | Equivalent to clicking the New Window command on the Window menu |
| NEXT | Ends a FOR-NEXT, FOR |
| NOTE | Equivalent to choosing the Comment command from the Insert menu |
| OBJECT.PROPERTIES | Determines how the selected object or objects are attached to the cells beneath them and whether they are printed |
| OBJECT.PROTECTION | Changes the protection status of the selected object |
| ON.DATA | Runs a specified macro when another application sends data to a particular workbook via dynamic data exchange (DDE) or via Publish and Subscribe on the Macintosh |
| ON.DOUBLECLICK | Runs a macro when you double-click any cell or object on the specified sheet or macro sheet or double-click any item on the specified chart |
| ON.ENTRY | Runs a macro when you enter data into any cell on the specified sheet |
| ON.KEY | Runs a specified macro when a particular key or key combination is pressed |
| ON.RECALC | Runs a macro when a specific sheet is recalculated |
| ON.SHEET | Starts a macro whenever the specified sheet is activated from another sheet |
| ON.TIME | Runs a macro at a specified time |
| ON.WINDOW | Runs a specified macro when you switch to a particular window |
| OPEN | Equivalent to clicking the Open command on the File menu |
| OPEN.DIALOG | Displays the standard Microsoft Excel File Open dialog box with the specified file filters |
| OPEN.LINKS | Equivalent to clicking the Links command on the Edit menu |
| OPEN.MAIL | Equivalent to clicking the Open Mail command on the Mail submenu on File menu |
| OPEN.TEXT | Equivalent to using the Text Import Wizard to open a text file in Microsoft Excel |
| OPTIONS.CALCULATION | Equivalent to clicking the Options command on the Tools menu, and clicking the Calculation tab in the Options dialog box |
| OPTIONS.CHART | Equivalent to clicking the Options command on the Tools menu and then clicking the Chart Tab in the Options dialog box when a chart is activated for editing |
| OPTIONS.EDIT | Equivalent to clicking the Options command on the tools menu and then clicking the Edit tab in the Options dialog box |
| OPTIONS.GENERAL | Equivalent to clicking the Options command on the Tools menu and then clicking the General tab from the Options dialog box |
| OPTIONS.LISTS.ADD | This is the equivalent to clicking the Options command on the Tools menu and then clicking the Custom Lists tab in the Options diralog box |
| OPTIONS.LISTS.DELETE | Equivalent to clicking the Options command on the Tools menu and then clicking the Delete button on the Custom Lists tab when a custom list is selected |
| OPTIONS.LISTS.GET | Returns contents of custom AutoFill lists as an array of text strings |
| OPTIONS.TRANSITION | Equivalent to clicking the Options command on the Tools menu and then clicking the Transition tab in the Options dialog box |
| OPTIONS.VIEW | Equivalent to clicking the Options command on the Tools menu and then clicking the View tab in the Options dialog box |
| OUTLINE | Creates an outline and defines settings for automatically creating outlines |
| OVERLAY | Equivalent to choosing the Overlay command from the Format menu in Microsoft Excel version 2 |
| PAGE.SETUP | Equivalent to clicking the Page Setup command on the File menu |
| PARSE | Distributes the contents of the current selection to fill several adjacent columns; the selection can be no more than one column wide |
| PASTE | Equivalent to clicking the Paste command on the Edit menu |
| PASTE.LINK | Equivalent to clicking the Paste Special command on the Edit menu, and then clicking the Paste Link button in the Paste Special dialog box |
| PASTE.PICTURE | Equivalent to clicking the Paste Picture command on the Edit menu while holding down the SHIFT key in Microsoft Excel version 4 |
| PASTE.PICTURE.LINK | Equivalent to holding down the SHIFT key and clicking the Paste Picture Link command on the Edit menu in Microsoft Excel version 4 |
| PASTE.SPECIAL | Equivalent to clicking the Paste Special command on the Edit menu |
| PASTE.TOOL | Pastes a button face from the Clipboard to a specified position on a toolbar |
| PATTERNS | Equivalent to clicking the Patterns tab in the Format Cells dialog box, which appears when you click the Cells command on the Format menu |
| PAUSE | Pauses a macro |
| PIVOT.ADD.DATA | Adds a field to a PivotTable report |
| PIVOT.ADD.FIELDS | Add fields onto a PivotTable report |
| PIVOT.FIELD | Pivots a field within a PivotTable report |
| PIVOT.FIELD.GROUP | Creates groups within a PivotTable report |
| PIVOT.FIELD.PROPERTIES | Changes the properties of a field inside a PivotTable report |
| PIVOT.FIELD.UNGROUP | Ungroups all selected groups within a PivotTable report |
| PIVOT.ITEM | Moves an item within a PivotTable report |
| PIVOT.ITEM.PROPERTIES | Changes the properties of an item within a header field |
| PIVOT.REFRESH | Refreshes a PivotTable report |
| PIVOT.SHOW.PAGES | Creates new sheets in the workbook containing the active cell |
| PIVOT.TABLE.WIZARD | Creates an empty PivotTable report |
| PLACEMENT | Equivalent to choosing the Object Placement command from the Format menu in Microsoft Excel version 3 |
| POKE | Sends data to another application |
| PRECISION | Equivalent to selecting or clearing the Precision As Displayed check box in the Calculation tab of the Options dialog box, which appears when you click the Options command on the Tools menu |
| PREFERRED | Equivalent to clicking the Preferred command on the Gallery menu in Microsoft Excel version 4 |
| PRESS.TOOL | Formats a button so that it appears either normal or depressed into the screen |
| Equivalent to clicking the Print command on the File menu | |
| PRINTER.SETUP | Use PRINTER |
| PRINT.PREVIEW | Equivalent to clicking the Print Preview command on the File menu |
| PROMOTE | Equivalent to clicking the Ungroup button |
| PROTECT.DOCUMENT | Adds protection to or removes protection from the active sheet, macro sheet, chart, dialog sheet, module, or scenario |
| PTTESTM | Performs a paired two-sample Student's t-Test for means |
| PTTESTV | Performs a two-sample Student's t-Test, assuming unequal variances |
| PUSHBUTTON.PROPERTIES | Sets the properties of the push button control on a worksheet or dialog sheet |
| QUERY.GET.DATA | Builds a new query using the supplied information |
| QUERY.REFRESH | Refreshes the data in a data range returned to a worksheet from Microsoft Query |
| QUIT | Equivalent to clicking the Exit command on the File menu in Microsoft Excel for Windows |
| RANDOM | Fills a range with independent random or patterned numbers drawn from one of several distributions |
| RANKPERC | Returns a table that contains the ordinal and percent rank of each value in a data set |
| REFTEXT | Converts a reference to an absolute reference in the form of text |
| REGISTER | Registers the specified dynamic link library (DLL) or code resource and returns the register ID |
| REGRESS | Performs multiple linear regression analysis |
| RELREF | Returns the reference of a cell or cells relative to the upper-left cell of rel_to_ref |
| REMOVE.LIST.ITEM | Removes an item in a list box or drop-down box |
| REMOVE.PAGE.BREAK | Equivalent to clicking the Remove Page Break command on the Insert menu |
| RENAME.COMMAND | Changes the name of a built-in or custom menu command or the name of a menu |
| RENAME.OBJECT | Renames the selected object or group |
| REPLACE.FONT | Replaces one of the four built-in fonts in Microsoft Excel for Windows version 2 |
| REPORT.DEFINE | Equivalent to clicking the Report Manager command on the View menu and then clicking the Add option in the Report Manager dialog box |
| REPORT.DELETE | Equivalent to clicking the Report Manager command on the View menu and then selecting a report in the Report Manager dialog box and clicking the Delete button |
| REPORT.GET | Returns information about reports defined for the active workbook |
| REPORT.PRINT | Equivalent to clicking the Print button in the Report Manager dialog box |
| REQUEST | Requests an array of a specific type of information from an application with which you have a dynamic data exchange (DDE) link |
| RESET.TOOL | Resets a button to its original button face |
| RESET.TOOLBAR | Resets built-in toolbars to the default Microsoft Excel set |
| RESTART | Removes a number of RETURN statements from the stack |
| RESULT | Specifies the type of data a macro or custom function returns |
| RESUME | Equivalent to choosing the Resume button on the toolbar |
| RETURN | Ends the currently running macro |
| ROUTE.DOCUMENT | Routes the workbook using the defined routing slip information |
| ROUTING.SLIP | Equivalent to clicking the Add Routing Slip command on the File menu |
| ROW.HEIGHT | Equivalent to choosing the Height command on the Row submenu of the Format menu |
| RUN | Equivalent to choosing the Run button in the Macro dialog box, which appears when you choose the Macros command on the Macro submenu of the Tools menu |
| SAMPLE | Samples data |
| SAVE | Equivalent to choosing the Save command from the File menu |
| SAVE.AS | Equivalent to clicking the Save As command on the File menu |
| SAVE.COPY.AS | Saves a copy of the current workbook using a different name but all the current workbook settings, such as passwords and file protection |
| SAVE.DIALOG | Displays the standard Microsoft Excel File Save As dialog box and gets a file name from the user |
| SAVE.TOOLBAR | Saves one or more toolbar definitions to a specified file |
| SAVE.WORKBOOK | Equivalent to clicking the Save Workbook command on the File menu in Microsoft Excel version 4 |
| SAVE.WORKSPACE | Equivalent to clicking the Save Workspace command on the File menu |
| SCALE | Changes the position, formatting, and scaling of axes in a chart |
| SCENARIO.ADD | Equivalent to clicking the Scenarios command on the Tools menu and then clicking the Add button |
| SCENARIO.CELLS | Equivalent to clicking the Scenarios command on the Tools menu and then editing the Changing Cells box |
| SCENARIO.DELETE | Equivalent to clicking the Scenarios command on the Tools menu, clicking a scenario, and then clicking the Delete button |
| SCENARIO.EDIT | Equivalent to clicking the Scenarios command from the Tools menu and then clicking the Edit button |
| SCENARIO.GET | Returns the specified information about the scenarios defined on your worksheet |
| SCENARIO.MERGE | Equivalent to choosing the Scenarios command from the Tools menu and then selecting Merge |
| SCENARIO.SHOW | Equivalent to clicking the Scenarios command on the Tools menu and then selecting a scenario and clicking the Show button |
| SCENARIO.SHOW.NEXT | Equivalent to clicking the Scenarios command on the Tools menu, selecting the next scenario from the Scenarios list, and clicking the Show button |
| SCENARIO.SUMMARY | Equivalent to clicking the Scenarios command on the Tools menu and then clicking the Summary button |
| SCROLLBAR.PROPERTIES | Sets the properties of the scroll bar and spinner button on a worksheet or dialog sheet |
| SELECT | Equivalent to selecting cells or changing the active cell |
| SELECT.ALL | Equivalent to selecting all the sheets in a workbook |
| SELECT.CHART | Equivalent to the Select Chart command on the Chart menu in Microsoft Excel version 4 |
| SELECT.END | Selects the cell at the edge of the range or the first cell of the next range in the direction specified |
| SELECTION | Returns the reference or object identifier of the selection as an external reference |
| SELECT.LAST.CELL | Equivalent to choosing the Special button from the Go To dialog box and selecting the Last Cell option |
| SELECT.LIST.ITEM | Selects an item in a list box or in a group box |
| SELECT.PLOT.AREA | Equivalent to clicking the Select Plot Area command on the Chart menu in Microsoft Excel version 4 |
| SELECT.SPECIAL | Equivalent to clicking the Go To command on the Edit menu and then selecting the Special button |
| SEND.KEYS | Sends keystrokes to the active application just as if they were typed at the keyboard |
| SEND.MAIL | Equivalent to clicking the Send Mail command on the File menu |
| SEND.TO.BACK | Sends the selected object or objects to the back |
| SERIES.AXES | Equivalent to the Axis Tab in the Format Data Series dialog box |
| SERIES.ORDER | Changes the order of series in a chart |
| SERIES.X | Equivalent to the X Values tab in the Format Data Series dialog box |
| SERIES.Y | Equivalent to the Name and Values tab in the Format Data Series dialog box |
| SET.CONTROL.VALUE | Changes the value for the active control, such as a list box, drop-down box, check box, option button, scroll bar, and spinner button |
| SET.CRITERIA | Equivalent to clicking the Set Criteria command on the Data menu in Microsoft Excel version 4 |
| SET.DATABASE | Equivalent to clicking the Set Database command on the Data menu in Microsoft Excel version 4 |
| SET.DIALOG.DEFAULT | Sets which button is automatically pressed (the default button) when the user presses ENTER |
| SET.DIALOG.FOCUS | Sets the focus of a dialog box |
| SET.EXTRACT | Equivalent to clicking the Set Extract command on the Data menu in Microsoft Excel version 4 |
| SET.LIST.ITEM | Sets the text of an item in a list box or drop-down box control |
| SET.NAME | Defines a name on a macro sheet to refer to a value |
| SET.PAGE.BREAK | Equivalent to clicking the Page Break command on the Insert menu |
| SET.PREFERRED | Changes the default format that Microsoft Excel uses when you create a new chart or when you format a chart PREFERRED macro function |
| SET.PRINT.AREA | Defines the print area for the workbook—the area that prints when you click the Print command on the File menu |
| SET.PRINT.TITLES | Defines the print titles for the sheet |
| SET.UPDATE.STATUS | Sets the update status of a link to automatic or manual |
| SET.VALUE | Changes the value of a cell or cells on the macro sheet (not the worksheet) without changing any formulas entered in those cells |
| SHORT.MENUS | Equivalent to clicking the Short Menus command on the Options menu or the Chart menu in Microsoft Excel version 3 |
| SHOW.ACTIVE.CELL | Scrolls the active window so the active cell becomes visible |
| SHOW.BAR | Displays the specified menu bar |
| SHOW.CLIPBOARD | Displays the contents of the Clipboard in a new window |
| SHOW.DETAIL | Expands or collapses the detail under the specified expand or collapse button |
| SHOW.DIALOG | Runs a dialog on a dialog sheet |
| SHOW.INFO | This function should not be used |
| SHOW.LEVELS | Displays the specified number of row and column levels of an outline |
| SHOW.TOOLBAR | Equivalent to selecting the check box corresponding to a toolbar on the Toolbars tab in the Customize dialog box, which appears when you select the Customize command (View menu, Toolbars submenu) |
| SIZE | Equivalent to clicking the Size command on the Control menu in Microsoft Excel for Windows version 3 |
| SLIDE.COPY.ROW | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.CUT.ROW | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.DEFAULTS | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.DELETE.ROW | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.EDIT | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.GET | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.PASTE | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.PASTE.ROW | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SLIDE.SHOW | This function should not be used in Microsoft Excel 95 or later because the Slide Show add-in is available only in Microsoft Excel version 5 |
| SOLVER.ADD | Equivalent to clicking the Solver command on the Tools menu and clicking the Add button in the Solver Parameters dialog box |
| SOLVER.CHANGE | Equivalent to clicking the Solver command on the Tools menu and clicking the Change button in the Solver Parameters dialog box |
| SOLVER.DELETE | Equivalent to clicking the Solver command on the Tools menu and clicking the Delete button in the Solver Parameters dialog box |
| SOLVER.FINISH | Equivalent to clicking OK in the Solver Results dialog box that appears when the solution process is complete |
| SOLVER.GET | Returns information about current settings for Solver |
| SOLVER.LOAD | Equivalent to clicking the Solver command on the Tools menu, clicking the Options button in the Solver Parameters dialog box, and clicking the Load Model button in the Solver Options dialog box |
| SOLVER.OK | Equivalent to clicking the Solver command on the Tools menu and specifying options in the Solver Parameters dialog box |
| SOLVER.OPTIONS | Equivalent to clicking the Solver command on the Tools menu and then clicking the Options button in the Solver Parameters dialog box |
| SOLVER.RESET | Equivalent to clicking the Solver command on the Tools menu and clicking the Reset All button in the Solver Parameters dialog box |
| SOLVER.SAVE | Equivalent to clicking the Solver command on the Tools menu, clicking the Options button in the Solver Parameters dialog box, and clicking the Save Model button in the Solver Options dialog box |
| SOLVER.SOLVE | Equivalent to clicking the Solver command on the Tools menu and clicking the Solve button in the Solver Parameters dialog box |
| SORT | Equivalent to clicking the Sort command on the Data menu |
| SOUND.NOTE | This function should not be used in Microsoft Excel 97 or later because sound notes are available only in Microsoft Excel 95 or earlier versions |
| SOUND.PLAY | This function should not be used in Microsoft Excel 97 or later because sound notes are available only in Microsoft Excel 95 or earlier versions |
| SPELLING | Equivalent to clicking the Spelling command on the Tools menu |
| SPELLING.CHECK | Checks the spelling of a word |
| SPLIT | Equivalent to choosing the Split command from the Window menu or to dragging the split bar in the active window's scroll bar |
| SQL.BIND | Specifies where results from a SQL query are placed when they are retrieved with SQL |
| SQL.CLOSE | Terminates a connection to an external data source |
| SQL.ERROR | Returns detailed error information when it is called after a previous XLODBC |
| SQL.EXEC.QUERY | Sends a query to a data source using an existing connection |
| SQL.GET.SCHEMA | Returns information about the structure of the data source on a particular connection |
| SQL.OPEN | Establishes a connection with a data source |
| SQL.RETRIEVE | Retrieves all or part of the results from a previously executed query |
| SQL.RETRIEVE.TO.FILE | Retrieves all of the results from a previously executed query and places them in a file |
| STANDARD.FONT | Sets the attributes of the standard font in Microsoft Excel version 2 |
| STANDARD.WIDTH | Sets the default width used for all columns that you have not previously adjusted on the active worksheet |
| STEP | Stops the normal flow of a macro and calculates it one cell at a time |
| STYLE | Checks the fonts for a bold and/or italic font and applies it to the current selection in Microsoft Excel for the Macintosh version 1 |
| SUBSCRIBE.TO | Inserts the contents of the edition into the active sheet at the point of the current selection |
| SUBTOTAL.CREATE | Equivalent to clicking the Subtotals command on the Data menu |
| SUBTOTAL.REMOVE | Equivalent to clicking the Subtotal command on the Data menu, and then clicking the Remove All button in the Subtotal dialog box |
| SUMMARY.INFO | Equivalent to clicking the Properties command on the File menu |
| TABLE | Equivalent to clicking the Table command on the Data menu |
| TAB.ORDER | This function determines the order in which dialog controls will be selected when the user presses the TAB key |
| TERMINATE | Closes a dynamic data exchange (DDE) channel previously opened with the INITIATE function |
| TEXT.BOX | Replaces characters in a text box or button with the text you specify |
| TEXTREF | Converts text to an absolute reference in either A1- or R1C1-style |
| TEXT.TO.COLUMNS | Equivalent to clicking the Text To Columns command on the Data menu when a column of data is to be separated into multiple columns |
| TRACER.CLEAR | Equivalent to clicking the Remove All Arrows button on the Auditing toolbar on a worksheet |
| TRACER.DISPLAY | Equivalent to clicking the Trace Precedents or Trace Dependents buttons on the Auditing toolbar on a worksheet |
| TRACER.ERROR | Equivalent to clicking the Trace Error button on the Auditing toolbar on a worksheet |
| TRACER.NAVIGATE | Equivalent to double-clicking on a displayed tracer arrow |
| TTESTM | Performs a two-sample Student's t-Test for means, assuming equal variances |
| UNDO | Equivalent to clicking the Undo command on the Edit menu |
| UNGROUP | Separates a grouped object into individual objects |
| UNHIDE | Equivalent to clicking the Unhide command on the Window menu |
| UNLOCKED.NEXT UNLOCKED.PREV | Equivalent to pressing TAB or SHIFT+TAB to move to the next or previous unlocked cell in a protected worksheet |
| UNREGISTER | Unregisters a previously registered dynamic link library (DLL) or code resource |
| UPDATE.LINK | Equivalent to clicking the Links command on the Edit menu and clicking the Update Now button with a link selected in the Links dialog box |
| VBA.INSERT.FILE | Inserts a text file containing code directly into your Visual Basic module |
| VBA.MAKE.ADDIN | Converts a workbook containing Visual Basic procedures into an add-in |
| VIEW.3D | Equivalent to clicking the 3-D View command on the Format menu in Microsoft Excel version 4 |
| VIEW.DEFINE | Equivalent to clicking the Add button in the Custom Views dialog box in Microsoft Excel 97 or later, which appears when you click the Custom Views command on the View menu |
| VIEW.DELETE | Equivalent to selecting a view and clicking the Delete button in the Custom Views dialog box, which appears when you click the Custom Views command on the View menu |
| VIEW.GET | Equivalent to displaying a list of views in the Custom Views dialog box, which appears when you click the Custom Views command on the View menu |
| VIEW.SHOW | Equivalent to selecting a view and clicking the Show button in the Custom Views dialog box, which appears when you click the Custom Views command on the View menu |
| VLINE | Scrolls through the active window vertically by the number of rows you specify |
| VOLATILE | Specifies whether a custom worksheet function is volatile or nonvolatile |
| VPAGE | Vertically scrolls through the active window one window at a time |
| VSCROLL | Vertically scrolls through the active sheet by percentage or by row number |
| WAIT | Pauses the macro until the time specified by the serial number |
| WHILE | Carries out the statements between the WHILE function and the next NEXT function until logical_test is FALSE |
| WINDOW.MAXIMIZE | Changes the active window from its normal size to full size |
| WINDOW.MINIMIZE | Shrinks a window to an icon |
| WINDOW.MOVE | Equivalent to clicking the Move command on the Control menu in Microsoft Excel for Windows or moving a window by dragging its title bar or its icon |
| WINDOW.RESTORE | Changes the active window from maximized or minimized size to its previous size |
| WINDOWS | Returns the names of the specified open Microsoft Excel windows, including hidden windows |
| WINDOW.SIZE | Equivalent to clicking the Size command on the Control menu or to adjusting the sizing borders (in Microsoft Excel for Windows) or the sizing box (in Microsoft Excel for the Macintosh) of the window with the mouse |
| WINDOW.TITLE | Changes the title of the active window to the title you specify |
| WORKBOOK.ACTIVATE | Equivalent to activating a worksheet by clicking on its tab |
| WORKBOOK.COPY | Equivalent to clicking the Move or Copy Sheet command on the Edit menu |
| WORKBOOK.DELETE | Equivalent to clicking the Delete Sheet command on the Edit menu |
| WORKBOOK.HIDE | Equivalent to clicking the Sheet command on the Format menu, and then clicking Hide on the Sheet submenu |
| WORKBOOK.INSERT | Equivalent to clicking the Worksheet, Chart, or Macro commands on the Insert menu |
| WORKBOOK.MOVE | Equivalent to clicking the Move or Copy Sheet command on the Edit menu |
| WORKBOOK.NAME | Equivalent to clicking the Rename command on the Sheet submenu of the Format menu |
| WORKBOOK.NEW | Adds a sheet to a workbook |
| WORKBOOK.NEXT | Activates the next sheet in the active workbook |
| WORKBOOK.OPTIONS | Equivalent to selecting the Options button in a workbook contents window in Microsoft Excel version 4 |
| WORKBOOK.PREV | Activates the previous sheet in the workbook |
| WORKBOOK.PROTECT | Equivalent to clicking the Protect Workbook command on the Protection submenu of the Tools menu |
| WORKBOOK.SCROLL | Scrolls through the sheets in a workbook |
| WORKBOOK.SELECT | Equivalent to selecting a sheet or group of sheets in the active workbook |
| WORKBOOK.TAB.SPLIT | Sets the ratio of the tabs to the horizontal scrollbar |
| WORKBOOK.UNHIDE | Equivalent to clicking the Unhide command on the sheet submenu of the Format menu |
| WORKGROUP | Equivalent to clicking the Group Edit command on the Options menu in Microsoft Excel version 4 |
| WORKSPACE | Changes the workspace settings for a workbook |
| ZOOM | Equivalent to choosing the Zoom command from the View menu |
| ZTESTM | Performs a two-sample z-test for means, assuming the two samples have known variances |