XL: List of XLM Macro Functions AvailableID: Q103751
|
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.
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 Last Reviewed: April 6, 1999