Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

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.