Microsoft KB Archive/103751

{|
 * width="100%"|

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 :