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 |
