## XL: List of XLM Macro Functions Available

The information in this article applies to:

- Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
- Microsoft Excel for the Macintosh, versions 4.0, 5.0

## SUMMARY

Following are the 386 macro functions available in Microsoft Excel. This list also includes the functions that are available with the CROSSTAB.XLL, SLIDES.XLA, and Solver add-in macros.

## MORE INFORMATION

A1.R1C1()

       ABSREF()
       ACTIVATE()
       ACTIVATE.NEXT()
       ACTIVATE.PREV()
       ACTIVE.CELL()
       ADD.ARROW()
       ADD.BAR()
       ADD.COMMAND()
       ADD.MENU()
       ADD.OVERLAY()
       ADD.TOOL()
       ADD.TOOLBAR()
       ALERT()
       ALIGNMENT()
       ANOVA1()
       ANOVA2()
       ANOVA3()
       APP.ACTIVATE()
       APP.MAXIMIZE()
       APP.MINIMIZE()
       APP.MOVE()
       APP.RESTORE()
       APP.SIZE()
       APP.TITLE()
       APPLY.NAMES()
       APPLY.STYLE()
       ARGUMENT()
       ARRANGE.ALL()
       ASSIGN.TO.OBJECT()
       ASSIGN.TO.TOOL()
       ATTACH.TEXT()
       AXES()
       BEEP()
       BORDER()
       BREAK()
       BRING.TO.FRONT()
       CALCULATE.DOCUMENT()
       CALCULATE.NOW()
       CALCULATION()
       CALLER()
       CANCEL.COPY()
       CANCEL.KEY()
       CELL.PROTECTION()
       CHANGE.LINK()
       CHART.WIZARD()
       CHECK.COMMAND()
       CLEAR()
       CLOSE()
       CLOSE.ALL()
       COLOR.PALETTE()
       COLUMN.WIDTH()
       COMBINATION()
       CONSOLIDATE()
       CONSTRAIN.NUMERIC()
       COPY()
       COPY.CHART()
       COPY.PICTURE()
       COPY.TOOL()
       CREATE.DIRECTORY()
       CREATE.NAMES()
       CREATE.OBJECT()
       CREATE.PUBLISHER()
       CROSSTAB.CREATE()
       CROSSTAB.DRILLDOWN()
       CROSSTAB.RECALC()
       CUSTOM.REPEAT()
       CUSTOM.UNDO()
       CUSTOMIZE.TOOLBAR?()
       CUT()
       DATA.DELETE()
       DATA.FIND()
       DATA.FIND.NEXT()
       DATA.FIND.PREV()
       DATA.FORM()
       DATA.SERIES()
       DEFINE.NAME()
       DELETE.ARROW()
       DELETE.BAR()
       DELETE.COMMAND()
       DELETE.DIRECTORY()
       DELETE.FORMAT()
       DELETE.MENU()
       DELETE.OVERLAY()
       DELETE.TOOL()
       DELETE.TOOLBAR()
       DEMOTE()
       DEREF()
       DESCR()
       DIALOG.BOX()
       DIRECTORIES()
       DIRECTORY()
       DISABLE.INPUT()
       DISPLAY()
       DOCUMENTS()
       DUPLICATE()
       ECHO()
       EDIT.COLOR()
       EDIT.DELETE()
       EDIT.OBJECT()
       EDIT.REPEAT()
       EDIT.SERIES()
       EDITION.OPTIONS()
       ELSE()
       ELSE.IF()
       EMBED()
       ENABLE.COMMAND()
       ENABLE.TOOL()
       END.IF()
       ENTER.DATA()
       ERROR()
       EVALUATE()
       EXEC()
       EXECUTE()
       EXPON()
       EXTEND.POLYGON()
       EXTRACT()
       FCLOSE()
       FILE.CLOSE()
       FILE.DELETE()
       FILE.EXISTS()
       FILES()
       FILL.AUTO()
       FILL.DOWN()
       FILL.GROUP()
       FILL.LEFT()
       FILL.RIGHT()
       FILL.UP()
       FOPEN()
       FOR()
       FOR.CELL()
       FORMAT.AUTO()
       FORMAT.FONT()
       FORMAT.LEGEND()
       FORMAT.MAIN()
       FORMAT.MOVE()
       FORMAT.NUMBER()
       FORMAT.OVERLAY()
       FORMAT.SHAPE()
       FORMAT.SIZE()
       FORMAT.TEXT()
       FORMULA()
       FORMULA.ARRAY ()
       FORMULA.CONVERT()
       FORMULA.FILL()
       FORMULA.FIND()
       FORMULA.GOTO()
       FORMULA.REPLACE()
       FOURIER()
       FPOS()
       FREAD()
       FREADLN()
       FREEZE.PANES()
       FSIZE()
       FTESTV()
       FULL()
       FWRITE()
       FWRITELN()
       GALLER.3D.PIE()
       GALLERY.3D.AREA()
       GALLERY.3D.BAR()
       GALLERY.3D.COLUMN()
       GALLERY.3D.LINE()
       GALLERY.3D.SURFACE()
       GALLERY.AREA()
       GALLERY.BAR()
       GALLERY.COLUMN()
       GALLERY.LINE()
       GALLERY.PIE()
       GALLERY.RADAR()
       GALLERY.SCATTER()
       GET.BAR()
       GET.CELL()
       GET.CHART.ITEM()
       GET.DEF()
       GET.DOCUMENT()
       GET.FORMULA()
       GET.LINK.INFO()
       GET.NAME()
       GET.NOTE()
       GET.OBJECT()
       GET.TOOL()
       GET.TOOLBAR()
       GET.WINDOW()
       GET.WORKBOOK()
       GET.WORKSPACE()
       GOAL.SEEK()
       GOTO()
       GRIDLINES()
       GROUP()
       HALT()
       HELP()
       HIDE()
       HIDE.OBJECT()
       HISTOGRAM()
       HLINE()
       HPAGE()
       HSCROLL()
       IF()
       INITIATE()
       INPUT()
       INSERT()
       INSERT.OBJECT()
       LAST.ERROR()
       LEGEND()
       LINE.PRINT()
       LINKS()
       LIST.NAMES()
       MCORREL()
       MCOVAR()
       MESSAGE()
       MOVE()
       MOVE.TOOL()
       MOVEAVG()
       NAMES()
       NEW()
       NEW.WINDOW()
       NEXT()
       NOTE()
       OBJECT.PROPERTIES()
       OBJECT.PROTECTION()
       ON.DATA()
       ON.DOUBLECLICK()
       ON.ENTRY()
       ON.KEY()
       ON.RECALC()
       ON.TIME()
       ON.WINDOW()
       OPEN()
       OPEN.LINKS()
       OPEN.MAIL()
       OUTLINE()
       PAGE.SETUP()
       PARSE()
       PASTE()
       PASTE.LINK()
       PASTE.PICTURE()
       PASTE.PICTURE.LINK()
       PASTE.SPECIAL()
       PASTE.TOOL()
       PATTERNS()
       PAUSE()
       PLACEMENT()
       POKE()
       PRECISION()
       PREFERRED()
       PRESS.TOOL()
       PRINT()
       PRINT.PREVIEW()
       PROMOTE()
       PROTECT.DOCUMENT()
       PTTESTM()
       PTTESTV()
       QUIT()
       RANDOM()
       RANKPERC()
       REFTEXT()
       REGISTER()
       REGISTER.ID()
       REGRESS()
       RELREF()
       REMOVE.PAGE.BREAK()
       RENAME.COMMAND()
       REPORT.DEFINE()
       REPORT.DELETE()
       REPORT.GET()
       REPORT.PRINT()
       REQUEST()
       RESET.TOOL()
       RESET.TOOLBAR()
       RESTART()
       RESULT()
       RESUME()
       RETURN()
       ROW.HEIGHT()
       RUN()
       SAMPLE()
       SAVE()
       SAVE.AS()
       SAVE.TOOLBAR()
       SAVE.WORKBOOK()
       SCALE()
       SCENARIO.ADD()
       SCENARIO.CELLS()
       SCENARIO.DELETE()
       SCENARIO.GET()
       SCENARIO.SHOW()
       SCENARIO.SHOW.NEXT()
       SCENARIO.SUMMARY()
       SELECT()
       SELECT.CHART()
       SELECT.END()
       SELECT.LAST.CELL()
       SELECT.PLOT.AREA()
       SELECT.SPECIAL()
       SELECTION()
       SEND.KEYS()
       SEND.MAIL()
       SEND.TO.BACK()
       SET.CRITERIA()
       SET.DATABASE()
       SET.EXTRACT()
       SET.NAME()
       SET.PAGE.BREAK()
       SET.PREFERRED()
       SET.PRINT.AREA()
       SET.PRINT.TITLES()
       SET.UPDATE.STATUS()
       SET.VALUE()
       SHARE()
       SHARE.NAME()
       SHOW.ACTIVE.CELL()
       SHOW.BAR()
       SHOW.CLIPBOARD()
       SHOW.DETAIL()
       SHOW.INFO()
       SHOW.LEVELS()
       SHOW.TOOLBAR()
       SLIDE.COPY.ROW()
       SLIDE.CUT.ROW()
       SLIDE.DEFAULTS()
       SLIDE.DELETE.ROW()
       SLIDE.EDIT()
       SLIDE.GET()
       SLIDE.PASTE()
       SLIDE.PASTE.ROW()
       SLIDE.SHOW()
       SOLVER.ADD()
       SOLVER.CHANGE()
       SOLVER.DELETE()
       SOLVER.FINISH()
       SOLVER.GET()
       SOLVER.LOAD()
       SOLVER.OK()
       SOLVER.OPTIONS()
       SOLVER.RESET()
       SOLVER.SAVE()
       SOLVER.SOLVE()
       SORT()
       SOUND.NOTE()
       SOUND.PLAY()
       SPELLING()
       SPELLING.CHECK()
       SPLIT()
       STEP()
       SUBSCRIBE.TO()
       TABLE()
       TERMINATE()
       TEXT.BOX()
       TEXTREF()
       TTESTM()
       UNDO()
       UNGROUP()
       UNHIDE()
       UNLOCKED.NEXT()
       UNLOCKED.PREV()
       UNREGISTER()
       UPDATE.LINK()
       VIEW.3D()
       VIEW.DEFINE()
       VIEW.DELETE()
       VIEW.GET()
       VIEW.SHOW()
       VLINE()
       VOLATILE()
       VPAGE()
       VSCROLL()
       WAIT()
       WHILE()
       WINDOW.MAXIMIZE()
       WINDOW.MINIMIZE()
       WINDOW.MOVE()
       WINDOW.RESTORE()
       WINDOW.SIZE()
       WINDOW.TITLE()
       WINDOWS()
       WORKBOOK.ACTIVATE()
       WORKBOOK.ADD()
       WORKBOOK.COPY()
       WORKBOOK.MOVE()
       WORKBOOK.OPTIONS()
       WORKBOOK.SELECT()
       WORKGROUP()
       WORKSPACE()
       ZOOM()
       ZTESTM()

Additional query words: dialog box 4.00a

Keywords : kbmacro
Version : WINDOWS: 4.0,4.0a,5.0; MACINTOSH: 4.0,5.0
Platform : MACINTOSH WINDOWS
Issue type : kbinfo
Technology :

Last Reviewed: April 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use.