Export (0) Print
Expand All

_Application Members

Represents the entire Microsoft Excel application.

The _Application type exposes the following members.

  NameDescription
Public property _Default Reserved for internal use.
Public property ActiveCell Returns a Range object that represents the active cell in the active window (the window on top) or in the specified window. If the window isn't displaying a worksheet, this property fails.
Public property ActiveChart Returns a Chart object that represents the active chart (either an embedded chart or a chart sheet). An embedded chart is considered active when it's either selected or activated. When no chart is active, this property returns Nothing.
Public property ActiveDialog Reserved for internal use.
Public property ActiveEncryptionSession Read-only.
Public property ActiveMenuBar Reserved for internal use.
Public property ActivePrinter Returns or sets the name of the active printer.
Public property ActiveProtectedViewWindow Gets a ProtectedViewWindow object that represents the active Protected View window (the window on top).
Public property ActiveSheet Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active.
Public property ActiveWindow Returns a Window object that represents the active window (the window on top). Returns Nothing if there are no windows open.
Public property ActiveWorkbook Returns a Workbook object that represents the workbook in the active window (the window on top). Returns Nothing if there are no windows open or if either the Info window or the Clipboard window is the active window.
Public property AddIns Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu).
Public property AddIns2 Gets a collection of AddIns2 objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.
Public property AlertBeforeOverwriting True if Microsoft Excel displays a message before overwriting nonblank cells during a drag-and-drop editing operation.
Public property AltStartupPath Returns or sets the name of the alternate startup folder.
Public property AlwaysUseClearType Returns or sets a Boolean that represents whether to use ClearType to display fonts in the menu, Ribbon, and dialog box text. Read/write.
Public property AnswerWizard Returns the AnswerWizard object for Microsoft Excel.
Public property Application Returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object).
Public property ArbitraryXMLSupportAvailable Returns a Boolean value that indicates whether the XML features in Microsoft Excel are available.
Public property AskToUpdateLinks True if Microsoft Excel asks the user to update links when opening files with links. False if links are automatically updated with no dialog box.
Public property Assistance Returns an IAssistance object for short_Excel2007 that represents the Microsoft Office Help Viewer. Read-only.
Public property Assistant Returns an Assistant object for Microsoft Excel.
Public property AutoCorrect Returns an AutoCorrect object that represents the Microsoft Excel AutoCorrect attributes.
Public property AutoFormatAsYouTypeReplaceHyperlinks True (default) if Microsoft Excel automatically formats hyperlinks as you type. False if Excel does not automatically format hyperlinks as you type.
Public property AutomationSecurity Returns or sets an MsoAutomationSecurity constant that represents the security mode Microsoft Excel uses when programmatically opening files.
Public property AutoPercentEntry True if entries in cells formatted as percentages aren’t automatically multiplied by 100 as soon as they are entered.
Public property AutoRecover Returns an AutoRecover object, which backs up all file formats on a timed interval.
Public property Build Returns the Microsoft Excel build number.
Public property CalculateBeforeSave True if workbooks are calculated before they're saved to disk (if the Calculation property is set to xlManual). This property is preserved even if you change the Calculation property.
Public property Calculation Returns or sets the calculation mode. Read/write XlCalculation.
Public property CalculationInterruptKey Sets or returns an XlCalculationInterruptKey constant that specifies the key that can interrupt Microsoft Excel when performing calculations.
Public property CalculationState Returns an XlCalculationState constant that indicates the calculation state of the application for any calculations that are being performed in Microsoft Excel.
Public property CalculationVersion Returns a number whose rightmost four digits are the minor calculation engine version number, and whose other digits (on the left) are the major version of Microsoft Excel.
Public property Caller Returns information about how Visual Basic was called (for more information, see the Remarks section).
Public property CanPlaySounds This property should not be used. Sound notes have been removed from Microsoft Excel.
Public property CanRecordSounds This property should not be used. Sound notes have been removed from Microsoft Excel.
Public property Caption The name that appears in the title bar of the main Microsoft Excel window. If you don't set a name, or if you set the name to Empty, this property returns "Microsoft Excel".
Public property CellDragAndDrop True if dragging and dropping cells is enabled.
Public property Cells Returns a Range object that represents all the cells on the active worksheet. If the active document isn’t a worksheet, this property fails.
Public property Charts Returns a Sheets collection that represents all the chart sheets in the active workbook.
Public property ClipboardFormats Returns the formats that are currently on the Clipboard as an array of numeric values. To determine whether a particular format is on the Clipboard, compare each element in the array with the appropriate constant listed in the Remarks section.
Public property ClusterConnector Gets or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins.
Public property ColorButtons Reserved for internal use.
Public property Columns Returns a Range object that represents all the columns on the active worksheet. If the active document isn't a worksheet, the Columns property fails.
Public property COMAddIns Returns the COMAddIns collection for Microsoft Excel, which represents the currently installed COM add-ins.
Public property CommandBars Returns a CommandBars object that represents the Microsoft Excel command bars.
Public property CommandUnderlines Returns or sets the state of the command underlines in Microsoft Excel for the Macintosh.
Public property ConstrainNumeric True if handwriting recognition is limited to numbers and punctuation only.
Public property ControlCharacters True if Microsoft Excel displays control characters for right-to-left languages.
Public property CopyObjectsWithCells True if objects are cut, copied, extracted, and sorted with cells.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C.
Public property Cursor Returns or sets the appearance of the mouse pointer in Microsoft Excel.
Public property CursorMovement Returns or sets a value that indicates whether a visual cursor or a logical cursor is used. Can be one of the following constants: xlVisualCursor or xlLogicalCursor.
Public property CustomListCount Returns the number of defined custom lists (including built-in lists).
Public property CutCopyMode Returns or sets the status of Cut or Copy mode.
Public property DataEntryMode Returns or sets Data Entry mode, as shown in the table below. When in Data Entry mode, you can enter data only in the unlocked cells in the currently selected range.
Public property DDEAppReturnCode Returns the application-specific DDE return code that was contained in the last DDE acknowledge message received by Microsoft Excel.
Public property DecimalSeparator Sets or returns the character used for the decimal separator as a String.
Public property DefaultFilePath Returns or sets the default path that Microsoft Excel uses when it opens files.
Public property DefaultSaveFormat Returns or sets the default format for saving files.
Public property DefaultSheetDirection Returns or sets the default direction in which Microsoft Excel displays new windows and worksheets. Can be one of the following constants: xlRTL (right to left) or xlLTR (left to right).
Public property DefaultWebOptions Returns the DefaultWebOptions object that contains global application-level attributes used by Microsoft Excel whenever you save a document as a Web page or open a Web page.
Public property DeferAsyncQueries Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write.
Public property Dialogs Returns a Dialogs collection that represents all built-in dialog boxes.
Public property DialogSheets Reserved for internal use.
Public property DisplayAlerts True if Microsoft Excel displays certain alerts and messages while a macro is running.
Public property DisplayClipboardWindow Returns True if the Microsoft Office Clipboard can be displayed.
Public property DisplayCommentIndicator Returns or sets the way cells display comments and indicators. Can be one of the following XlCommentDisplayMode constants: xlNoIndicator, xlCommentIndicatorOnly, or xlCommentAndIndicator.
Public property DisplayDocumentActionTaskPane Set to True to display the Document Actions task pane; set to False to hide the Document Actions task pane.
Public property DisplayDocumentInformationPanel Returns or sets a Boolean that represents whether the document properties panel is displayed. Read/write.
Public property DisplayExcel4Menus True if Microsoft Excel displays version 4.0 menu bars.
Public property DisplayFormulaAutoComplete Gets or sets whether to show a list of relevant functions and defined names when building cell formulas. Read/write.
Public property DisplayFormulaBar True if the formula bar is displayed.
Public property DisplayFullScreen True if Microsoft Excel is in full-screen mode.
Public property DisplayFunctionToolTips True if function ToolTips can be displayed.
Public property DisplayInfoWindow Reserved for internal use.
Public property DisplayInsertOptions True if the Insert Options button should be displayed.
Public property DisplayNoteIndicator True if cells containing notes display cell tips and contain note indicators (small dots in their upper-right corners).
Public property DisplayPasteOptions True if the Paste Options button can be displayed.
Public property DisplayRecentFiles True if the list of recently used files is displayed on the File menu.
Public property DisplayScrollBars True if scroll bars are visible for all workbooks.
Public property DisplayStatusBar True if the status bar is displayed.
Public property Dummy101 Reserved for internal use.
Public property EditDirectlyInCell True if Microsoft Excel allows editing in cells.
Public property EnableAnimations True if animated insertion and deletion is enabled.
Public property EnableAutoComplete True if the AutoComplete feature is enabled.
Public property EnableCancelKey Controls how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure. Read/write XlEnableCancelKey.
Public property EnableEvents True if events are enabled for the specified object.
Public property EnableLargeOperationAlert Sets or returns a Boolean that represents whether to display an alert message when a user attempts to perform an operation that affects a larger number of cells than is specified in the Office center UI. Read/write.
Public property EnableLivePreview Sets or returns a Boolean that represents whether to show or hide gallery previews that appear when using galleries that support previewing. Setting this property to True shows a preview of your workbook before applying the command. Read/write.
Public property EnableSound True if sound is enabled for Microsoft Office.
Public property EnableTipWizard Reserved for internal use.
Public property ErrorCheckingOptions Returns an ErrorCheckingOptions object, which represents the error checking options for an application.
Public property Excel4IntlMacroSheets Returns a Sheets collection that represents all the Microsoft Excel 4.0 international macro sheets in the specified workbook.
Public property Excel4MacroSheets Returns a Sheets collection that represents all the Microsoft Excel 4.0 macro sheets in the specified workbook.
Public property ExtendList True if Microsoft Excel automatically extends formatting and formulas to new data that is added to a list.
Public property FeatureInstall Returns or sets a value (constant) that specifies how Microsoft Excel handles calls to methods and properties that require features that aren’t yet installed. Read/write MsoFeatureInstall.
Public property FileConverters Returns information about installed file converters. Returns Null if there are no converters installed.
Public property FileDialog Returns a FileDialog object representing an instance of the file dialog.
Public property FileExportConverters Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
Public property FileFind You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.
Public property FileSearch Returns a FileSearch object for use with file searches. This property is available only in Microsoft Windows.
Public property FileValidation Gets or sets how Microsoft Excel will validate files before opening them.
Public property FileValidationPivot Gets or sets how Microsoft Excel will validate the contents of the data caches for PivotTable reports.
Public property FindFormat Sets or returns the search criteria for the type of cell formats to find.
Public property FixedDecimal All data entered after this property is set to True will be formatted with the number of fixed decimal places set by the FixedDecimalPlaces property.
Public property FixedDecimalPlaces Returns or sets the number of fixed decimal places used when the FixedDecimal property is set to True.
Public property FormulaBarHeight Allows the user to specify the height of the formula bar in lines. Read/write.
Public property GenerateGetPivotData Returns True when Microsoft Excel can get PivotTable report data.
Public property GenerateTableRefs The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas. Read/write.
Public property Height The height, in points, of the main application window. If the window is minimized, this property is read-only and refers to the height of the icon. If the window is maximized, this property cannot be set. Use the WindowState property to determine the window state.
Public property HideChartDraftModeNotification Reserved for internal use.
Public property HighQualityModeForGraphics Gets or sets whether Excel uses high quality mode to print graphics.
Public property Hinstance Returns the instance handle of the instance that is calling Microsoft Excel.
Public property HinstancePtr Gets a handle to the instance of Microsoft Excel 2010 represented by the specified _Application object.
Public property Hwnd Returns an Integer indicating the top-level window handle of the Microsoft Excel window.
Public property IgnoreRemoteRequests True if remote DDE requests are ignored.
Public property InsertChartInDraftMode Reserved for internal use.
Public property Interactive True if Microsoft Excel is in interactive mode; this property is usually True. If you set this property to False, Microsoft Excel will block all input from the keyboard and mouse (except input to dialog boxes that are displayed by your code). Blocking user input will prevent the user from interfering with the code as it moves or activates Microsoft Excel objects.
Public property International Returns information about the current country/region and international settings.
Public property IsSandboxed Gets whether the specified workbook is open in a Protected View window.
Public property Iteration True if Microsoft Excel will use iteration to resolve circular references.
Public property LanguageSettings Returns the LanguageSettings object, which contains information about the language settings in Microsoft Excel.
Public property LargeButtons Reserved for internal use.
Public property LargeOperationCellThousandCount Returns or sets the maximum number of cells needed in an operation beyond which an alert is triggered. Read/write.
Public property Left The distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window.
Public property LibraryPath Returns the path to the Library folder but without the final separator.
Public property MailSession Returns the MAPI mail session number as a hexadecimal string (if there's an active session), or returns Null if there's no session.
Public property MailSystem Returns the mail system that's installed on the host machine. Read-only XlMailSystem.
Public property MapPaperSize True if documents formatted for the standard paper size of another country/region (for example, A4) are automatically adjusted so that they're printed correctly on the standard paper size (for example, Letter) of your country/region.
Public property MathCoprocessorAvailable True if a math coprocessor is available.
Public property MaxChange Returns or sets the maximum amount of change between each iteration as Microsoft Excel resolves circular references.
Public property MaxIterations Returns or sets the maximum number of iterations that Microsoft Excel can use to resolve a circular reference.
Public property MeasurementUnit Specifies the measurement unit used in the application. Read/write Integer value corresponding to the constants in the XlMeasurementUnits enumeration.
Public property MemoryFree Returns the amount of memory that's still available for Microsoft Excel to use, in bytes.
Public property MemoryTotal Reserved for internal use.
Public property MemoryUsed Reserved for internal use.
Public property MenuBars Reserved for internal use.
Public property Modules Reserved for internal use.
Public property MouseAvailable True if a mouse is available.
Public property MoveAfterReturn True if the active cell will be moved as soon as the ENTER (RETURN) key is pressed.
Public property MoveAfterReturnDirection Returns or sets the direction in which the active cell is moved when the user presses ENTER. Read/write XlDirection.
Public property MultiThreadedCalculation Returns a MultiThreadedCalculation object that controls the multi-threaded recalculation settings that are new in Excel 2007. Read-only.
Public property Name Returns the name of the object.
Public property Names Returns a Names collection that represents all the names in the active workbook.
Public property NetworkTemplatesPath Returns the network path where templates are stored. If the network path doesn’t exist, this property returns an empty string.
Public property NewWorkbook Returns a NewFile object.
Public property ODBCErrors Returns an ODBCErrors collection that contains all the ODBC errors generated by the most recent query table or PivotTable report operation.
Public property ODBCTimeout Returns or sets the ODBC query time limit in seconds. The default value is 45 seconds.
Public property OLEDBErrors Returns the OLEDBErrors collection, which represents the error information returned by the most recent OLE DB query.
Public property OnCalculate Reserved for internal use.
Public property OnData Reserved for internal use.
Public property OnDoubleClick Reserved for internal use.
Public property OnEntry Reserved for internal use.
Public property OnSheetActivate Reserved for internal use.
Public property OnSheetDeactivate Reserved for internal use.
Public property OnWindow Returns or sets the name of the procedure that’s run whenever you activate a window.
Public property OperatingSystem Returns the name and version number of the current operating system, for example, "Windows (32-bit) 4.00" or "Macintosh 7.00".
Public property OrganizationName Returns the registered organization name.
Public property Parent Returns the parent object for the specified object.
Public property Path Returns the complete path to the application, excluding the final separator and name of the application.
Public property PathSeparator Returns the path separator character ("\").
Public property PivotTableSelection True if PivotTable reports use structured selection.
Public property PreviousSelections Returns an array of the last four ranges or names selected. Each element in the array is a Range object.
Public property PrintCommunication Gets or sets whether communication with the printer is turned on.
Public property ProductCode Returns the globally unique identifier (GUID) for Microsoft Excel.
Public property PromptForSummaryInfo True if Microsoft Excel asks for summary information when files are first saved.
Public property ProtectedViewWindows Gets a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application.
Public property Quitting Reserved for internal use.
Public property Range Returns a Range object that represents a cell or a range of cells.
Public property Ready Returns True when the Microsoft Excel application is ready; False when the Excel application is not ready.
Public property RecentFiles Returns a RecentFiles collection that represents the list of recently used files.
Public property RecordRelative True if macros are recorded using relative references; False if recording is absolute.
Public property ReferenceStyle Returns or sets how Microsoft Excel displays cell references and row and column headings in either A1 or R1C1 reference style. Read/write XlReferenceStyle.
Public property RegisteredFunctions Returns information about functions in either dynamic-link libraries (DLLs) or code resources that were registered with the REGISTER or REGISTER.ID macro functions.
Public property ReplaceFormat Sets the replacement criteria to use in replacing cell formats. The replacement criteria is then used in a subsequent call to the Replace method of the Range object.
Public property RollZoom True if the IntelliMouse zooms instead of scrolling.
Public property Rows Returns a Range object that represents all the rows on the active worksheet. If the active document isn’t a worksheet, the Rows property fails.
Public property RTD Returns an RTD object.
Public property SaveISO8601Dates Gets or sets whether Excel saves date and time values using the ISO 8601 format.
Public property ScreenUpdating True if screen updating is turned on.
Public property Selection Returns the selected object in the active window.
Public property Sheets Returns a Sheets collection that represents all the sheets in the active workbook.
Public property SheetsInNewWorkbook Returns or sets the number of sheets that Microsoft Excel automatically inserts into new workbooks.
Public property ShortcutMenus Reserved for internal use.
Public property ShowChartTipNames True if charts show chart tip names. The default value is True.
Public property ShowChartTipValues True if charts show chart tip values. The default value is True.
Public property ShowDevTools Returns or sets a Boolean that represents whether the Developer tab is displayed in the Ribbon. Read/write.
Public property ShowMenuFloaties Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. Read/write.
Public property ShowSelectionFloaties Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. Read/write.
Public property ShowStartupDialog Returns True (default) when the New Workbook task pane appears for a Microsoft Excel application.
Public property ShowToolTips True if ToolTips are turned on.
Public property ShowWindowsInTaskbar True if there’s a separate Windows taskbar button for each open workbook. The default value is True.
Public property SmartArtColors Gets the set of color styles that are currently loaded in the application.
Public property SmartArtLayouts Gets the set of SmartArt layouts that are currently loaded in the application.
Public property SmartArtQuickStyles Gets the set of SmartArt quick styles which are currently loaded in the application.
Public property SmartTagRecognizers Returns a SmartTagRecognizers collection for an application.
Public property Speech Returns a Speech object.
Public property SpellingOptions Returns a SpellingOptions object that represents the spelling options of the application.
Public property StandardFont Returns or sets the name of the standard font.
Public property StandardFontSize Returns or sets the standard font size, in points.
Public property StartupPath Returns the complete path of the startup folder excluding the final separator.
Public property StatusBar Returns or sets the text in the status bar.
Public property TemplatesPath Returns the local path where templates are stored.
Public property ThisCell Returns the cell the user-defined function is being called from as a Range object.
Public property ThisWorkbook Returns a Workbook object that represents the workbook where the current macro code is running.
Public property ThousandsSeparator Sets or returns the character used for the thousands separator as a String.
Public property Toolbars Reserved for internal use.
Public property Top The distance, in points, from the top edge of the screen to the top edge of the main Microsoft Excel window. If the application window is minimized, this property controls the position of the window icon (anywhere on the screen).
Public property TransitionMenuKey Returns or sets the Microsoft Excel menu or help key, which is usually "/".
Public property TransitionMenuKeyAction Returns or sets the action taken when the Microsoft Excel menu key is pressed. Can be either xlExcelMenus or xlLotusHelp.
Public property TransitionNavigKeys True if transition navigation keys are active.
Public property UILanguage Reserved for internal use.
Public property UsableHeight Returns the maximum height of the space that a window can occupy in the application window area, in points.
Public property UsableWidth Returns the maximum width of the space that a window can occupy in the application window area in points.
Public property UseClusterConnector Gets or sets whether Microsoft Excel allows user-defined functions in XLL add-ins to be run on a compute cluster.
Public property UsedObjects Returns a UsedObjects object representing objects allocated in a workbook.
Public property UserControl True if the application is visible or if it was created or started by the user. False if you created or started the application programmatically by using the CreateObject or GetObject functions and the application is hidden.
Public property UserLibraryPath Returns the path to the location on the user’s computer where the COM add-ins are installed.
Public property UserName Returns or sets the name of the current user.
Public property UseSystemSeparators True (default) if the system separators of Microsoft Excel are enabled.
Public property Value Returns "Microsoft Excel".
Public property VBE Returns a VBE object that represents the Visual Basic Editor.
Public property Version Returns the Microsoft Excel version number.
Public property Visible Determines whether the object is visible.
Public property WarnOnFunctionNameConflict The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean.
Public property Watches Returns a Watches object representing a range which is tracked when the worksheet is recalculated.
Public property Width The distance, in points, from the left edge of the application window to its right edge. If the window is minimized, this property is read-only and returns the width of the window icon.
Public property Windows Returns a Windows collection that represents all the windows in all the workbooks.
Public property WindowsForPens True if the computer is running under Microsoft Windows for Pen Computing.
Public property WindowState Returns or sets the state of the window. Read/write XlWindowState.
Public property Workbooks Returns a Workbooks collection that represents all the open workbooks.
Public property WorksheetFunction Returns the WorksheetFunction object.
Public property Worksheets Returns a Sheets collection that represents all the worksheets in the active workbook.
Top

  NameDescription
Public method _Evaluate Reserved for internal use.
Public method _FindFile Reserved for internal use.
Public method _Run2 Reserved for internal use.
Public method _Wait Reserved for internal use.
Public method _WSFunction Reserved for internal use.
Public method ActivateMicrosoftApp Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.
Public method AddChartAutoFormat Adds a custom chart autoformat to the list of available chart autoformats.
Public method AddCustomList Adds a custom list for custom autofill and/or custom sort.
Public method Calculate Calculates all open workbooks
Public method CalculateFull Forces a full calculation of the data in all open workbooks.
Public method CalculateFullRebuild For all open workbooks, forces a full calculation of the data and rebuilds the dependencies.
Public method CalculateUntilAsyncQueriesDone Runs all pending queries to OLEDB and OLAP data sources.
Public method CentimetersToPoints Converts a measurement from centimeters to points (one point equals 0.035 centimeters).
Public method CheckAbort Stops recalculation in a Microsoft Excel application.
Public method CheckSpelling Checks the spelling of a single word. Returns True if the word is found in one of the dictionaries; returns False if the word isn't found.
Public method ConvertFormula Converts cell references in a formula between the A1 and R1C1 reference styles, between relative and absolute references, or both.
Public method DDEExecute Runs a command or performs some other action or actions in another application by way of the specified DDE channel.
Public method DDEInitiate Opens a DDE channel to an application.
Public method DDEPoke Sends data to an application.
Public method DDERequest Requests information from the specified application. This method always returns an array.
Public method DDETerminate Closes a channel to another application.
Public method DeleteChartAutoFormat Removes a custom chart autoformat from the list of available chart autoformats.
Public method DeleteCustomList Deletes a custom list.
Public method DisplayXMLSourcePane Opens the XML Source task pane and displays the XML map specified by the XmlMap argument.
Public method DoubleClick Equivalent to double-clicking the active cell.
Public method Dummy1 Reserved for internal use.
Public method Dummy10 Reserved for internal use.
Public method Dummy11 Reserved for internal use.
Public method Dummy12 Reserved for internal use.
Public method Dummy13 Reserved for internal use.
Public method Dummy14 Reserved for internal use.
Public method Dummy2 Reserved for internal use.
Public method Dummy20 Reserved for internal use.
Public method Dummy3 Reserved for internal use.
Public method Dummy4 Reserved for internal use.
Public method Dummy5 Reserved for internal use.
Public method Dummy6 Reserved for internal use.
Public method Dummy7 Reserved for internal use.
Public method Dummy8 Reserved for internal use.
Public method Dummy9 Reserved for internal use.
Public method Evaluate Converts a Microsoft Excel name to an object or a value.
Public method ExecuteExcel4Macro Runs a Microsoft Excel 4.0 macro function, and then returns the result of the function. The return type depends on the function.
Public method FindFile Displays the Open dialog box.
Public method GetCustomListContents Returns a custom list (an array of strings).
Public method GetCustomListNum Returns the custom list number for an array of strings. You can use this method to match both built-in lists and custom-defined lists.
Public method GetOpenFilename Displays the standard Open dialog box and gets a file name from the user without actually opening any files.
Public method GetPhonetic Returns the Japanese phonetic text of the specified text string. This method is available to you only if you have selected or installed Japanese language support for Microsoft Office.
Public method GetSaveAsFilename Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.
Public method Goto Selects any range or Visual Basic procedure in any workbook and activates that workbook if it’s not already active.
Public method Help Displays a Help topic.
Public method InchesToPoints Converts a measurement from inches to points.
Public method InputBox Displays a dialog box for user input. Returns the information entered in the dialog box.
Public method Intersect Returns a Range object that represents the rectangular intersection of two or more ranges.
Public method MacroOptions Corresponds to options in the Macro Options dialog box. You can also use this method to display a user defined function (UDF) in a built-in or new category within the Insert Function dialog box.
Public method MacroOptions2 Reserved for internal use.
Public method MailLogoff Closes a MAPI mail session established by Microsoft Excel.
Public method MailLogon Logs in to MAPI Mail or Microsoft Exchange and establishes a mail session. If Microsoft Mail isn't already running, you must use this method to establish a mail session before mail or document routing functions can be used.
Public method NextLetter You have requested Help for a Visual Basic keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition.
Public method OnKey Runs a specified procedure when a particular key or key combination is pressed.
Public method OnRepeat Sets the Repeat menu item and the name of the procedure that will run if you choose the Repeat command (Edit menu) after running the procedure that sets this property.
Public method OnTime Schedules a procedure to be run at a specified time in the future (either at a specific time of day or after a specific amount of time has passed).
Public method OnUndo Sets the text of the Undo and the name of the procedure that’s run if you choose the Undo command (Edit menu) after running the procedure that sets this property.
Public method Quit Quits Microsoft Excel.
Public method RecordMacro Records code if the macro recorder is on.
Public method RegisterXLL Loads an XLL code resource and automatically registers the functions and commands contained in the resource.
Public method Repeat Repeats the last user interface action.
Public method ResetTipWizard Resets the routing slip so that a new routing can be initiated with the same slip (using the same recipient list and delivery information). The routing must be completed before you use this method. Using this method at other times causes an error.
Public method Run Runs a macro or calls a function.
Public method Save Saves changes to the specified workbook.
Public method SaveWorkspace Saves the current workspace.
Public method SendKeys Sends keystrokes to the active application.
Public method SetDefaultChart Specifies the name of the chart template that Microsoft Excel will use when creating new charts.
Public method SharePointVersion Returns the version number of SharePoint Foundation instances running at site for the specified URL.
Public method Support Reserved for internal use.
Public method Undo Cancels the last user interface action.
Public method Union Returns the union of two or more ranges.
Public method Volatile Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.
Public method Wait Pauses a running macro until a specified time. Returns True if the specified time has arrived.
Top

Community Additions

ADD
Show:
© 2014 Microsoft