Microsoft KB Archive/103751

From BetaArchive Wiki

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.