Export (0) Print
Expand All
Expand Minimize

Microsoft.Office.Interop.Excel Namespace 

InterfaceDescription
_ApplicationRepresents the entire Microsoft Excel application.
_ChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
_Global 
_IOLEObject 
_IQueryTable 
_OLEObjectRepresents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
_QueryTableRepresents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
_WorkbookRepresents a Microsoft Excel workbook.
_WorksheetRepresents a worksheet.
AddInRepresents a single add-in, either installed or not installed.
AddInsA collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether they’re installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).
AdjustmentsContains a collection of adjustment values for the specified AutoShape, WordArt object, or connector.
AllowEditRangeRepresents the cells that can be edited on a protected worksheet.
AllowEditRangesA collection of all the AllowEditRange objects that represent the cells that can be edited on a protected worksheet.
AppEvents 
AppEvents_EventEvents interface for Microsoft Excel Application object events.
ApplicationRepresents the entire Microsoft Excel application.
Arc 
Arcs 
AreasA collection of the areas, or contiguous blocks of cells, within a selection.
AutoCorrectContains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).
AutoFilterRepresents autofiltering for the specified worksheet.
AutoRecoverRepresents the automatic recovery features of a workbook.
AxesA collection of all the Axis objects in the specified chart.
AxisRepresents a single axis in a chart.
AxisTitleRepresents a chart axis title.
BorderRepresents the border of an object.
BordersA collection of four Border objects that represent the four borders of a Range or Style object.
Button 
Buttons 
CalculatedFieldsA collection of PivotField objects that represents all the calculated fields in the specified PivotTable report.
CalculatedItemsA collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
CalculatedMemberRepresents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
CalculatedMembersA collection of all the CalculatedMember objects on the specified PivotTable. Each CalculatedMember object represents a calculated member or calculated measure.
CalloutFormatContains properties and methods that apply to line callouts.
CellFormatRepresents the search criteria for the cell format.
CharactersRepresents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.
ChartRepresents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.
ChartAreaRepresents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesn’t include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.
ChartColorFormatUsed only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.
ChartEvents 
ChartEvents_EventEvents interface for Microsoft Excel Chart object events.
ChartFillFormatUsed only with charts. Represents fill formatting for chart elements.
ChartGroupRepresents one or more series plotted in a chart with the same format. The ChartGroup object is a member of the ChartGroups collection.
ChartGroupsA collection of all the ChartGroup objects in the specified chart.
ChartObjectRepresents an embedded chart on a worksheet.
ChartObjectsA collection of all the ChartObject objects on the specified chart sheet, dialog sheet, or worksheet.
ChartsA collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesn’t include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.
ChartTitleRepresents the chart title.
CheckBox 
CheckBoxes 
ColorFormatRepresents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color.
CommentRepresents a cell comment.
CommentsA collection of cell comments. Each comment is represented by a Comment object.
ConnectorFormatContains properties and methods that apply to connectors.
ControlFormatContains Microsoft Excel control properties.
CornersRepresents the corners of a 3-D chart.
CubeFieldRepresents a hierarchy or measure field from an OLAP cube.
CubeFieldsA collection of all CubeField objects in a PivotTable report that is based on an OLAP cube.
CustomPropertiesA collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.
CustomPropertyRepresents identifier information. Identifier information can be used as metadata for XML.
CustomViewRepresents a custom workbook view.
CustomViewsA collection of custom workbook views. Each view is represented by a CustomView object.
DataLabelRepresents the data label on a chart point or trendline.
DataLabelsA collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.
DataTableRepresents a chart data table.
DefaultWebOptionsContains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
DiagramRepresents a diagram.
DiagramNodeRepresents a node in a diagram.
DiagramNodeChildrenA collection of DiagramNode objects that represents child nodes in a diagram.
DiagramNodesA collection of DiagramNode objects that represents all the nodes in a diagram.
DialogRepresents a built-in Microsoft Excel dialog box.
DialogFrame 
DialogsA collection of all the Dialog objects in Microsoft Excel.
DialogSheet 
DialogSheets 
DisplayUnitLabelRepresents a unit label on an axis in the specified chart.
DocEvents 
DocEvents_EventEvents interface for Microsoft Excel Worksheet object events.
DownBarsRepresents the down bars in a chart group.
Drawing 
DrawingObjects 
Drawings 
DropDown 
DropDowns 
DropLinesRepresents the drop lines in a chart group.
EditBox 
EditBoxes 
ErrorRepresents a spreadsheet error for a range.
ErrorBarsRepresents the error bars on a chart series.
ErrorCheckingOptionsRepresents the error-checking options for an application.
ErrorsRepresents the various spreadsheet errors for a range.
FillFormatRepresents fill formatting for a shape.
FilterRepresents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.
FiltersA collection of Filter objects that represents all the filters in an autofiltered range.
FloorRepresents the floor of a 3-D chart.
FontContains the font attributes (font name, font size, color, and so on) for an object.
FormatConditionRepresents a conditional format.
FormatConditionsRepresents the collection of conditional formats for a single range.
FreeformBuilderRepresents the geometry of a freeform while it’s being built.
Global 
GraphicContains properties that apply to header and footer picture objects.
GridlinesRepresents major or minor gridlines on a chart axis.
GroupBox 
GroupBoxes 
GroupObject 
GroupObjects 
GroupShapesRepresents the individual shapes within a grouped shape.
HiLoLinesRepresents the high-low lines in a chart group.
HPageBreakRepresents a horizontal page break.
HPageBreaksThe collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.
HyperlinkRepresents a hyperlink.
HyperlinksRepresents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.
IAddIn 
IAddIns 
IAllowEditRange 
IAllowEditRanges 
IAppEvents 
IArc 
IArcs 
IAreas 
IAutoCorrect 
IAutoFilter 
IAutoRecover 
IAxes 
IAxis 
IAxisTitle 
IBorder 
IBorders 
IButton 
IButtons 
ICalculatedFields 
ICalculatedItems 
ICalculatedMember 
ICalculatedMembers 
ICanvasShapes 
ICellFormat 
ICharacters 
IChartArea 
IChartColorFormat 
IChartEvents 
IChartFillFormat 
IChartGroup 
IChartGroups 
IChartObject 
IChartObjects 
ICharts 
IChartTitle 
ICheckBox 
ICheckBoxes 
IComment 
IComments 
IConnectorFormat 
IControlFormat 
ICorners 
ICustomProperties 
ICustomProperty 
ICustomView 
ICustomViews 
IDataLabel 
IDataLabels 
IDataTable 
IDiagram 
IDialog 
IDialogFrame 
IDialogs 
IDialogSheet 
IDialogSheets 
IDisplayUnitLabel 
IDocEvents 
IDownBars 
IDrawing 
IDrawingObjects 
IDrawings 
IDropDown 
IDropDowns 
IDropLines 
IDummy 
IEditBox 
IEditBoxes 
IError 
IErrorBars 
IErrorCheckingOptions 
IErrors 
IFilter 
IFilters 
IFloor 
IFont 
IFormatCondition 
IFormatConditions 
IFreeformBuilder 
IGraphic 
IGridlines 
IGroupBox 
IGroupBoxes 
IGroupObject 
IGroupObjects 
IGroupShapes 
IHiLoLines 
IHPageBreak 
IHPageBreaks 
IHyperlink 
IHyperlinks 
IInterior 
ILabel 
ILabels 
ILeaderLines 
ILegend 
ILegendEntries 
ILegendEntry 
ILegendKey 
ILine 
ILines 
ILinkFormat 
IListBox 
IListBoxes 
IListColumn 
IListColumns 
IListDataFormat 
IListObject 
IListObjects 
IListRow 
IListRows 
IMailer 
IMenu 
IMenuBar 
IMenuBars 
IMenuItem 
IMenuItems 
IMenus 
IModule 
IModules 
IName 
INames 
InteriorRepresents the interior of an object.
IODBCError 
IODBCErrors 
IOLEDBError 
IOLEDBErrors 
IOLEFormat 
IOLEObjectEvents 
IOLEObjects 
IOptionButton 
IOptionButtons 
IOutline 
IOval 
IOvals 
IPageSetup 
IPane 
IPanes 
IParameter 
IParameters 
IPhonetic 
IPhonetics 
IPicture 
IPictures 
IPivotCache 
IPivotCaches 
IPivotCell 
IPivotField 
IPivotFields 
IPivotFormula 
IPivotFormulas 
IPivotItem 
IPivotItemList 
IPivotItems 
IPivotLayout 
IPivotTable 
IPivotTables 
IPlotArea 
IPoint 
IPoints 
IProtection 
IPublishObjects 
IQueryTables 
IRange 
IRecentFile 
IRecentFiles 
IRectangle 
IRectangles 
IRefreshEvents 
IRoutingSlip 
IRTD 
IRtdServerRepresents an interface for a real-time data server.
IRTDUpdateEventRepresents real-time data update events.
IScenario 
IScenarios 
IScrollBar 
IScrollBars 
ISeries 
ISeriesCollection 
ISeriesLines 
IShape 
IShapeRange 
IShapes 
ISmartTag 
ISmartTagAction 
ISmartTagActions 
ISmartTagOptions 
ISmartTagRecognizer 
ISmartTagRecognizers 
ISmartTags 
ISoundNote 
ISpeech 
ISpellingOptions 
ISpinner 
ISpinners 
IStyle 
IStyles 
ITab 
ITextBox 
ITextBoxes 
ITextFrame 
ITickLabels 
IToolbar 
IToolbarButton 
IToolbarButtons 
IToolbars 
ITrendline 
ITrendlines 
IUpBars 
IUsedObjects 
IUserAccess 
IUserAccessList 
IValidation 
IVPageBreak 
IVPageBreaks 
IWalls 
IWatch 
IWatches 
IWindow 
IWindows 
IWorkbookEvents 
IWorksheetFunction 
IWorksheets 
IXmlDataBinding 
IXmlMap 
IXmlMaps 
IXmlNamespace 
IXmlNamespaces 
IXmlSchema 
IXmlSchemas 
IXPath 
Label 
Labels 
LeaderLinesRepresents leader lines on a chart.
LegendRepresents the legend in a chart.
LegendEntriesA collection of all the LegendEntry objects in the specified chart legend.
LegendEntryRepresents a legend entry in a chart legend.
LegendKeyRepresents a legend key in a chart legend.
Line 
LineFormatRepresents line and arrowhead formatting.
Lines 
LinkFormatContains linked OLE object properties.
ListBox 
ListBoxes 
ListColumnRepresents a column in a list. The ListColumn object is a member of the ListColumns collection. The ListColumns collection contains all the columns in a list (ListObject object).
ListColumnsA collection of all the ListColumn objects in the specified ListObject object. Each ListColumn object represents a column in the list.
ListDataFormatThe ListDataFormat object holds all the data type properties of the ListColumn object. These properties are read-only.
ListObjectRepresents a list object on a worksheet.
ListObjectsA collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.
ListRowRepresents a row in a List object. The ListRow object is a member of the ListRows collection. The ListRows collection contains all the rows in a list object.
ListRowsA collection of all the ListRow objects in the specified ListObject object. Each ListRow object represents a row in the list.
MailerYou 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.
Menu 
MenuBar 
MenuBars 
MenuItem 
MenuItems 
Menus 
Module 
Modules 
NameRepresents a defined name for a range of cells.
NamesA collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
ODBCErrorRepresents an ODBC error generated by the most recent ODBC query.
ODBCErrorsA collection of ODBCError objects.
OLEDBErrorRepresents an OLE DB error returned by the most recent OLE DB query.
OLEDBErrorsA collection of OLEDBError objects.
OLEFormatContains OLE object properties.
OLEObjectRepresents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.
OLEObjectEvents 
OLEObjectEvents_EventEvents interface for Microsoft Excel OLEObject object events.
OLEObjectsA collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.
OptionButton 
OptionButtons 
OutlineRepresents an outline on a worksheet.
Oval 
Ovals 
PageSetupRepresents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.
PaneRepresents a pane of a window.
PanesA collection of all the Pane objects shown in the specified window.
ParameterRepresents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.
ParametersA collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.
PhoneticContains information about a specific phonetic text string in a cell.
PhoneticsA collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.
Picture 
PictureFormatContains properties and methods that apply to pictures and OLE objects.
Pictures 
PivotCacheRepresents the memory cache for a PivotTable report.
PivotCachesRepresents the collection of memory caches from the PivotTable reports in a workbook.
PivotCellRepresents a cell in a PivotTable report.
PivotFieldRepresents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
PivotFieldsA collection of all the PivotField objects in a PivotTable report.
PivotFormulaRepresents a formula used to calculate results in a PivotTable report.
PivotFormulasRepresents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.
PivotItemRepresents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.
PivotItemListA collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.
PivotItemsA collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
PivotLayoutRepresents the placement of fields in a PivotChart report.
PivotTableRepresents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
PivotTablesA collection of all the PivotTable objects on the specified worksheet.
PlotAreaRepresents the plot area of a chart. This is the area where your chart data is plotted.
PointRepresents a single point in a series in a chart.
PointsA collection of all the Point objects in the specified series in a chart.
ProtectionRepresents the various types of protection options available for a worksheet.
PublishObjectRepresents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object.
PublishObjectsA collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.
QueryTableRepresents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.
QueryTablesA collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.
RangeRepresents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.
RecentFileRepresents a file in the list of recently used files.
RecentFilesRepresents the list of recently used files. Each file is represented by a RecentFile object.
Rectangle 
Rectangles 
RefreshEvents 
RefreshEvents_EventEvents interface for Microsoft Excel QueryTable object events.
RoutingSlipRepresents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.
RTDRepresents a real-time data object.
ScenarioRepresents a scenario on a worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
ScenariosA collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) that’s named and saved.
ScrollBar 
ScrollBars 
SeriesRepresents a series in a chart. The Series object is a member of the SeriesCollection collection.
SeriesCollectionA collection of all the Series objects in the specified chart or chart group.
SeriesLinesRepresents series lines in a chart group. Series lines connect the data values from each series.
ShadowFormatRepresents shadow formatting for a shape.
ShapeRepresents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.
ShapeNodeRepresents the geometry and the geometry-editing properties of the nodes in a user-defined freeform.
ShapeNodesA collection of all the ShapeNode objects in the specified freeform.
ShapeRangeRepresents a shape range, which is a set of shapes on a document.
ShapesA collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.
SheetsA collection of all the sheets in the specified or active workbook.
SmartTagRepresents an identifier that is assigned to a cell.
SmartTagActionRepresents the actions that can be performed with smart tags.
SmartTagActionsA collection of SmartTagAction objects that represent the actions that can be performed with smart tags.
SmartTagOptionsRepresents the options that can be performed with smart tags.
SmartTagRecognizerRepresents recognition engines which label data with types of information as you work in Microsoft Excel.
SmartTagRecognizersA collection of SmartTagRecognizer objects that represent recognition engines that label data with types of information as you work in Microsoft Excel.
SmartTagsA collection of SmartTag objects that represent the identifiers assigned to each cell.
SoundNoteThis object should not be used. Sound notes have been removed from Microsoft Excel.
SpeechContains methods and properties that pertain to speech.
SpellingOptionsRepresents the various spell-checking options for a worksheet.
Spinner 
Spinners 
StyleRepresents a style description for a range.
StylesA collection of all the Style objects in the specified or active workbook.
TabRepresents a tab in a chart or a worksheet.
TextBox 
TextBoxes 
TextEffectFormatContains properties and methods that apply to WordArt objects.
TextFrameRepresents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.
ThreeDFormatRepresents a shape's three-dimensional formatting.
TickLabelsRepresents the tick mark labels associated with tick marks on a chart axis.
Toolbar 
ToolbarButton 
ToolbarButtons 
Toolbars 
TreeviewControlRepresents the hierarchical member-selection control of a cube field. You use this object primarily for macro recording; it is not intended for any other use.
TrendlineRepresents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
TrendlinesA collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.
UpBarsRepresents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one).
UsedObjectsRepresents objects that have been allocated in a workbook.
UserAccessRepresents the user access for a protected range.
UserAccessListA collection of UserAccess objects that represent the user access for protected ranges.
ValidationRepresents data validation for a worksheet range.
VPageBreakRepresents a vertical page break.
VPageBreaksA collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.
WallsRepresents the walls of a 3-D chart.
WatchRepresents a range which is tracked when the worksheet is recalculated.
WatchesA collection of all the Watch objects in a specified application.
WebOptionsContains workbook-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page.
WindowRepresents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window.
WindowsA collection of all the Window objects in Microsoft Excel.
WorkbookRepresents a Microsoft Excel workbook.
WorkbookEvents 
WorkbookEvents_EventEvents interface for Microsoft Excel Workbook object events.
WorkbooksA collection of all the Workbook objects that are currently open in the Microsoft Excel application.
WorksheetRepresents a worksheet.
WorksheetFunctionUsed as a container for Microsoft Excel worksheet functions
WorksheetsA collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.
XmlDataBindingRepresents the connection to the source data for an XmlMap object.
XmlMapRepresents an XML map that has been added to a workbook.
XmlMapsRepresents the collection of XmlMap objects that have been added to a workbook.
XmlNamespaceRepresents a namespace that has been added to a workbook.
XmlNamespacesRepresents the collection of XmlNamespace objects in a workbook.
XmlSchemaRepresents an XML schema contained by an XmlMap object.
XmlSchemasRepresents the collection of XmlSchema objects contained by an XmlMap object.
XPathRepresents an XPath that has been mapped to a Range or ListColumn object.

DelegateDescription
AppEvents_NewWorkbookEventHandlerA Delegate type used to add an event handler for the NewWorkbook event. The NewWorkbook event occurs when a new workbook is created.
AppEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
AppEvents_SheetBeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
AppEvents_SheetBeforeRightClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
AppEvents_SheetCalculateEventHandlerA Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
AppEvents_SheetChangeEventHandlerA Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
AppEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
AppEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
AppEvents_SheetPivotTableUpdateEventHandlerA Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
AppEvents_SheetSelectionChangeEventHandlerA Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet.
AppEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
AppEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
AppEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.
AppEvents_WorkbookActivateEventHandlerA Delegate type used to add an event handler for the WorkbookActivate event. The WorkbookActivate event occurs when any workbook is activated.
AppEvents_WorkbookAddinInstallEventHandlerA Delegate type used to add an event handler for the WorkbookAddinInstall event. The WorkbookAddinInstall event occurs when a workbook is installed as an add-in.
AppEvents_WorkbookAddinUninstallEventHandlerA Delegate type used to add an event handler for the WorkbookAddinUninstall event. The WorkbookAddinUninstall event occurs when any add-in workbook is uninstalled.
AppEvents_WorkbookAfterXmlExportEventHandlerA Delegate type used to add an event handler for the WorkbookAfterXmlExport event. The WorkbookAfterXmlExport event occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.
AppEvents_WorkbookAfterXmlImportEventHandlerA Delegate type used to add an event handler for the WorkbookAfterXmlImport event. The WorkbookAfterXmlImport event occurs after an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
AppEvents_WorkbookBeforeCloseEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeClose event. The WorkbookBeforeClose event occurs immediately before any open workbook closes.
AppEvents_WorkbookBeforePrintEventHandlerA Delegate type used to add an event handler for the WorkbookBeforePrint event. The WorkbookBeforePrint event occurs before any open workbook is printed.
AppEvents_WorkbookBeforeSaveEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeSave event. The WorkbookBeforeSave event occurs before any open workbook is saved.
AppEvents_WorkbookBeforeXmlExportEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeXmlExport event. The WorkbookBeforeXmlExport event occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.
AppEvents_WorkbookBeforeXmlImportEventHandlerA Delegate type used to add an event handler for the WorkbookBeforeXmlImport event. The WorkbookBeforeXmlImport event occurs before an existing XML data connection is refreshed, or new XML data is imported into any open Microsoft Excel workbook.
AppEvents_WorkbookDeactivateEventHandlerA Delegate type used to add an event handler for the WorkbookDeactivate event. The WorkbookDeactivate event occurs when any open workbook is deactivated.
AppEvents_WorkbookNewSheetEventHandlerA Delegate type used to add an event handler for the WorkbookNewSheet event. The WorkbookNewSheet event occurs when a new sheet is created in any open workbook.
AppEvents_WorkbookOpenEventHandlerA Delegate type used to add an event handler for the WorkbookOpen event. The WorkbookOpen event occurs when a workbook is opened.
AppEvents_WorkbookPivotTableCloseConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableCloseConnection event. The WorkbookPivotTableCloseConnection event occurs after a PivotTable report connection has been closed.
AppEvents_WorkbookPivotTableOpenConnectionEventHandlerA Delegate type used to add an event handler for the WorkbookPivotTableOpenConnection event. The WorkbookPivotTableOpenConnection event occurs after a PivotTable report connection has been opened.
AppEvents_WorkbookSyncEventHandlerA Delegate type used to add an event handler for the WorkbookSync event. The WorkbookSync event occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.
ChartEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a chart sheet or embedded chart is activated.
ChartEvents_BeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when an embedded chart is double-clicked, before the default double-click action.
ChartEvents_BeforeRightClickEventHandlerA Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when an embedded chart is right-clicked, before the default right-click action.
ChartEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the chart plots new or changed data.
ChartEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the chart is deactivated.
ChartEvents_DragOverEventHandlerA Delegate type used to add an event handler for the DragOver event. The DragOver event occurs when a range of cells is dragged over a chart.
ChartEvents_DragPlotEventHandlerA Delegate type used to add an event handler for the DragPlot event. The DragPlot event occurs when a range of cells is dragged and dropped on a chart.
ChartEvents_MouseDownEventHandlerA Delegate type used to add an event handler for the MouseDown event. The MouseDown event occurs when a mouse button is pressed while the pointer is over a chart.
ChartEvents_MouseMoveEventHandlerA Delegate type used to add an event handler for the MouseMove event. The MouseMove event occurs when the position of the mouse pointer changes over a chart.
ChartEvents_MouseUpEventHandlerA Delegate type used to add an event handler for the MouseUp event. The MouseUp event occurs when a mouse button is released while the pointer is over a chart.
ChartEvents_ResizeEventHandlerA Delegate type used to add an event handler for the Resize event. The Resize event occurs when the chart is resized.
ChartEvents_SelectEventHandlerA Delegate type used to add an event handler for the Select event. The Select event occurs when a chart element is selected.
ChartEvents_SeriesChangeEventHandlerA Delegate type used to add an event handler for the SeriesChange event. The SeriesChange event occurs when the user changes the value of a chart data point.
DocEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a worksheet is activated.
DocEvents_BeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the BeforeDoubleClick event. The BeforeDoubleClick event occurs when a worksheet is double-clicked, before the default double-click action.
DocEvents_BeforeRightClickEventHandlerA Delegate type used to add an event handler for the BeforeRightClick event. The BeforeRightClick event occurs when a worksheet is right-clicked, before the default right-click action.
DocEvents_CalculateEventHandlerA Delegate type used to add an event handler for the Calculate event. The Calculate event occurs after the worksheet is recalculated.
DocEvents_ChangeEventHandlerA Delegate type used to add an event handler for the Change event. The Change event occurs when cells on the worksheet are changed by the user or by an external link.
DocEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the worksheet is deactivated.
DocEvents_FollowHyperlinkEventHandlerA Delegate type used to add an event handler for the FollowHyperlink event. The FollowHyperlink event occurs when you click any hyperlink on a worksheet.
DocEvents_PivotTableUpdateEventHandlerA Delegate type used to add an event handler for the PivotTableUpdate event. The PivotTableUpdate event occurs after a PivotTable report is updated on a worksheet.
DocEvents_SelectionChangeEventHandlerA Delegate type used to add an event handler for the SelectionChange event. The SelectionChange event occurs when the selection changes on a worksheet.
OLEObjectEvents_GotFocusEventHandlerA Delegate type used to add an event handler for the GotFocus event. The GotFocus event occurs when an ActiveX control gets input focus.
OLEObjectEvents_LostFocusEventHandlerA Delegate type used to add an event handler for the LostFocus event. The LostFocus event occurs when an ActiveX control loses input focus.
RefreshEvents_AfterRefreshEventHandlerA Delegate type used to add an event handler for the AfterRefresh event. The AfterRefresh event occurs after a query is completed or canceled.
RefreshEvents_BeforeRefreshEventHandlerA Delegate type used to add an event handler for the BeforeRefresh event. The BeforeRefresh event occurs before any refreshes of the query table.
WorkbookEvents_ActivateEventHandlerA Delegate type used to add an event handler for the Activate event. The Activate event occurs when a workbook is activated.
WorkbookEvents_AddinInstallEventHandlerA Delegate type used to add an event handler for the AddinInstall event. The AddinInstall event occurs when the workbook is installed as an add-in.
WorkbookEvents_AddinUninstallEventHandlerA Delegate type used to add an event handler for the AddinUninstall event. The AddinUninstall event occurs when the workbook is uninstalled as an add-in.
WorkbookEvents_AfterXmlExportEventHandlerA Delegate type used to add an event handler for the AfterXmlExport event. The AfterXmlExport event occurs after Microsoft Excel saves or exports data from the specified workbook to an XML data file.
WorkbookEvents_AfterXmlImportEventHandlerA Delegate type used to add an event handler for the AfterXmlImport event. The AfterXmlImport event occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
WorkbookEvents_BeforeCloseEventHandlerA Delegate type used to add an event handler for the BeforeClose event. The BeforeClose event occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
WorkbookEvents_BeforePrintEventHandlerA Delegate type used to add an event handler for the BeforePrint event. The BeforePrint event occurs before the workbook (or anything in it) is printed.
WorkbookEvents_BeforeSaveEventHandlerA Delegate type used to add an event handler for the BeforeSave event. The BeforeSave event occurs before the workbook is saved.
WorkbookEvents_BeforeXmlExportEventHandlerA Delegate type used to add an event handler for the BeforeXmlExport event. The BeforeXmlExport event occurs before Microsoft Excel saves or exports data from the specified workbook to an XML data file.
WorkbookEvents_BeforeXmlImportEventHandlerA Delegate type used to add an event handler for the BeforeXmlImport event. The BeforeXmlImport event occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
WorkbookEvents_DeactivateEventHandlerA Delegate type used to add an event handler for the Deactivate event. The Deactivate event occurs when the workbook is deactivated.
WorkbookEvents_NewSheetEventHandlerA Delegate type used to add an event handler for the NewSheet event. The NewSheet event occurs when a new sheet is created in the workbook.
WorkbookEvents_OpenEventHandlerA Delegate type used to add an event handler for the Open event. The Open event occurs when the workbook is opened.
WorkbookEvents_PivotTableCloseConnectionEventHandlerA Delegate type used to add an event handler for the PivotTableCloseConnection event. The PivotTableCloseConnection event occurs after a PivotTable report closes the connection to its data source.
WorkbookEvents_PivotTableOpenConnectionEventHandlerA Delegate type used to add an event handler for the PivotTableOpenConnection event. The PivotTableOpenConnection event occurs after a PivotTable report opens the connection to its data source.
WorkbookEvents_SheetActivateEventHandlerA Delegate type used to add an event handler for the SheetActivate event. The SheetActivate event occurs when any sheet is activated.
WorkbookEvents_SheetBeforeDoubleClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeDoubleClick event. The SheetBeforeDoubleClick event occurs when any worksheet is double-clicked, before the default double-click action.
WorkbookEvents_SheetBeforeRightClickEventHandlerA Delegate type used to add an event handler for the SheetBeforeRightClick event. The SheetBeforeRightClick event occurs when any worksheet is right-clicked, before the default right-click action.
WorkbookEvents_SheetCalculateEventHandlerA Delegate type used to add an event handler for the SheetCalculate event. The SheetCalculate event occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
WorkbookEvents_SheetChangeEventHandlerA Delegate type used to add an event handler for the SheetChange event. The SheetChange event occurs when cells in any worksheet are changed by the user or by an external link.
WorkbookEvents_SheetDeactivateEventHandlerA Delegate type used to add an event handler for the SheetDeactivate event. The SheetDeactivate event occurs when any sheet is deactivated.
WorkbookEvents_SheetFollowHyperlinkEventHandlerA Delegate type used to add an event handler for the SheetFollowHyperlink event. The SheetFollowHyperlink event occurs when you click any hyperlink in Microsoft Excel.
WorkbookEvents_SheetPivotTableUpdateEventHandlerA Delegate type used to add an event handler for the SheetPivotTableUpdate event. The SheetPivotTableUpdate event occurs after the sheet of the PivotTable report has been updated.
WorkbookEvents_SheetSelectionChangeEventHandlerA Delegate type used to add an event handler for the SheetSelectionChange event. The SheetSelectionChange event occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
WorkbookEvents_SyncEventHandlerA Delegate type used to add an event handler for the Sync event. The Sync event occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.
WorkbookEvents_WindowActivateEventHandlerA Delegate type used to add an event handler for the WindowActivate event. The WindowActivate event occurs when any workbook window is activated.
WorkbookEvents_WindowDeactivateEventHandlerA Delegate type used to add an event handler for the WindowDeactivate event. The WindowDeactivate event occurs when any workbook window is deactivated.
WorkbookEvents_WindowResizeEventHandlerA Delegate type used to add an event handler for the WindowResize event. The WindowResize event occurs when any workbook window is resized.

EnumerationDescription
ConstantsSpecifies global constants used in Microsoft Excel.
XlApplicationInternationalSpecifies country/region and international settings.
XlApplyNamesOrderSpecifies which range name is listed first when a cell reference is replaced by a row-oriented and column-oriented range name.
XlArabicModesSpecifies spelling rules for the Arabic spelling checker.
XlArrangeStyleSpecifies how windows are arranged on the screen.
XlArrowHeadLengthSpecifies the length of the arrowhead at the end of a line.
XlArrowHeadStyleSpecifies the type of arrowhead to apply to the line end.
XlArrowHeadWidthSpecifies the width of the arrowhead at the line end.
XlAutoFillTypeSpecifies how the target range is to be filled, based on the contents of the source range.
XlAutoFilterOperatorSpecifies the operator to use to associate two criteria applied by a filter.
XlAxisCrossesSpecifies the point on the specified axis where the other axis crosses.
XlAxisGroupSpecifies the type of axis group.
XlAxisTypeSpecifies the axis type.
XlBackgroundSpecifies the background type for text in charts.
XlBarShapeSpecifies the shape used with the 3-D bar or column chart.
XlBordersIndexSpecifies the border to be retrieved.
XlBorderWeightSpecifies the weight of the border around a range.
XlBuiltInDialogSpecifies which dialog box to display.
XlCalculatedMemberTypeSpecifies the type of a calculated member in a pivot table.
XlCalculationSpecifies the calculation mode.
XlCalculationInterruptKeySpecifies which key interrupts recalculation.
XlCalculationStateSpecifies the calculation state of the application.
XlCategoryTypeSpecifies the type of the category axis.
XlCellInsertionModeSpecifies the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a recordset returned by a query.
XlCellTypeSpecifies the type of cells.
XlChartGallerySpecifies a chart gallery.
XlChartItemSpecifies the type of the chart item.
XlChartLocationSpecifies where to relocate a chart.
XlChartPicturePlacementSpecifies the placement of a user-selected picture on a bar in a 3-D bar or column.
XlChartPictureTypeSpecifies how pictures are displayed on a column, bar picture chart, or legend key.
XlChartSplitTypeSpecifies the values displayed in the second chart in a pie chart or a bar of pie chart.
XlChartTypeSpecifies the chart type.
XlClipboardFormatSpecifies the format of an item on the Windows clipboard.
XlCmdTypeSpecifies the value of the CommandText property.
XlColorIndexSpecifies the color of a selected feature such as border, font, or fill.
XlColumnDataTypeSpecifies how a column is to be parsed.
XlCommandUnderlinesSpecifies the state of the command underlines in Microsoft Excel for the Macintosh.
XlCommentDisplayModeSpecifies the way cells display comments and comment indicators.
XlConsolidationFunctionSpecifies the subtotal function.
XlCopyPictureFormatSpecifies the format of the picture being copied.
XlCorruptLoadSpecifies the processing for a file when it is opened.
XlCreatorSpecifies the 32-bit creator code for Excel for Macintosh (decimal 1480803660, Hex 5843454C, string XCEL).
XlCubeFieldTypeSpecifies whether the OLAP field is a hierarchy, set, or measure field.
XlCutCopyModeSpecifies whether status is Copy mode or Cut mode.
XlCVErrorSpecifies the cell error number and value.
XlDataLabelPositionSpecifies where the data label is positioned.
XlDataLabelSeparatorSpecifies the separator used with data labels.
XlDataLabelsTypeSpecifies the type of data label to apply.
XlDataSeriesDateSpecifies the type of date to apply to a data series.
XlDataSeriesTypeSpecifies the data series to create.
XlDeleteShiftDirectionSpecifies how to shift cells to replace deleted cells.
XlDirectionSpecifies the direction in which to move.
XlDisplayBlanksAsSpecifies how blank cells are plotted on a chart.
XlDisplayDrawingObjectsSpecifies how shapes are displayed.
XlDisplayUnitSpecifies the display unit label for an axis.
XlDVAlertStyleSpecifies the icon used in message boxes displayed during validation.
XlDVTypeSpecifies the type of validation test to be performed in conjunction with values.
XlEditionFormatSpecifies the format of the published edition. This is Macintosh only and should not be used.
XlEditionOptionsOptionThis enumeration is for Macintosh only and should not be used.
XlEditionTypeSpecifies the type of edition to be changed.
XlEnableCancelKeySpecifies how Microsoft Excel handles CTRL+BREAK (or ESC or COMMAND+PERIOD) user interruptions to the running procedure.
XlEnableSelectionSpecifies what can be selected on the sheet.
XlEndStyleCapSpecifies the end style for error bars.
XlErrorBarDirectionSpecifies which axis values are to receive error bars.
XlErrorBarIncludeSpecifies which error bar parts to include.
XlErrorBarTypeSpecifies the range marked by error bars.
XlErrorChecksSpecifies the type of error object to be retrieved from the Errors collection.
XlFileAccessSpecifies the new access mode for the object.
XlFileFormatSpecifies the file format when saving the spreadsheet.
XlFillWithSpecifies how to copy the range.
XlFilterActionSpecifies whether data is to be copied or left in place during a filter operation.
XlFindLookInSpecifies the type of data to search.
XlFormatConditionOperatorSpecifies the operator to use to compare a formula against the value in a cell or, for xlBetween and xlNotBetween, to compare two formulas.
XlFormatConditionTypeSpecifies whether the conditional format is based on a cell value or an expression.
XlFormControlSpecifies the type of the form control.
XlFormulaLabelSpecifies the formula label type for the specified range.
XlHAlignSpecifies the horizontal alignment for the object.
XlHebrewModesSpecifies the mode for the Hebrew spelling checker.
XlHighlightChangesTimeSpecifies which set of changes is shown in a shared workbook.
XlHtmlTypeSpecifies the type of HTML generated by Microsoft Excel when you save the specified item to a Web page and whether the item is static or interactive.
XlIMEModeSpecifies the description of the Japanese input rules.
XlImportDataAsSpecifies the format in which to return data from a database.
XlInsertFormatOriginSpecifies from where to copy the format for inserted rows.
XlInsertShiftDirectionSpecifies the direction in which to shift cells during an insertion.
XlLayoutFormTypeSpecifies the way the specified PivotTable items appear—in table format or in outline format.
XlLegendPositionSpecifies the position of the legend on a chart.
XlLineStyleSpecifies the line style for the border.
XlLinkSpecifies the type of link.
XlLinkInfoSpecifies the type of information to be returned.
XlLinkInfoTypeSpecifies the type of link.
XlLinkStatusSpecifies the status of a link.
XlLinkTypeSpecifies the type of link.
XlListConflictSpecifies the conflict resolution options for updating a list on a Microsoft Windows SharePoint Services site with the changes made to a list in a Microsoft Excel worksheet.
XlListDataTypeSpecifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
XlListObjectSourceTypeSpecifies the current source of the list.
XlLocationInTableSpecifies the part of the PivotTable report that contains the upper-left corner of a range.
XlLookAtSpecifies whether a match is made against the whole of the search text or any part of the search text.
XlMailSystemSpecifies the mail system that is installed on the host machine.
XlMarkerStyleSpecifies the marker style for a point or series in a line chart, scatter chart, or radar chart.
XlMouseButtonSpecifies which mouse button was pressed.
XlMousePointerSpecifies the appearance of the mouse pointer in Microsoft Excel.
XlMSApplicationSpecifies a Microsoft application.
XlObjectSizeSpecifies the way a chart is scaled to fit on a page.
XlOLETypeSpecifies the OLE object type.
XlOLEVerbSpecifies the verb that the server of the OLE object should act on.
XlOrderSpecifies the order in which cells are processed.
XlOrientationSpecifies the text orientation.
XlPageBreakSpecifies page break location in the worksheet.
XlPageBreakExtentSpecifies whether a page break is full screen or applies only within the print area.
XlPageOrientationSpecifies the page orientation when the worksheet is printed.
XlPaperSizeSpecifies the size of the paper.
XlParameterDataTypeSpecifies the data type of a query parameter.
XlParameterTypeSpecifies how to determine the value of the parameter for the specified query table.
XlPasteSpecialOperationSpecifies how numeric data will be calculated with the destinations cells in the worksheet.
XlPasteTypeSpecifies the part of the range to be pasted.
XlPatternSpecifies the interior pattern of a chart or interior object.
XlPhoneticAlignmentSpecifies the alignment for phonetic text.
XlPhoneticCharacterTypeSpecifies the type of phonetic text in a cell.
XlPictureAppearanceSpecifies how the picture should be copied.
XlPictureConvertorTypeSpecifies how to convert a graphic.
XlPivotCellTypeSpecifies the PivotTable entity the cell corresponds to.
XlPivotFieldCalculationSpecifies the type of calculation performed by a data PivotField when a custom calculation is used.
XlPivotFieldDataTypeSpecifies the type of data in the PivotTable field.
XlPivotFieldOrientationSpecifies the location of the field in a PivotTable report.
XlPivotFormatTypeSpecifies the type of report formatting to be applied to the specified PivotTable report.
XlPivotTableMissingItemsSpecifies the maximum number of unique items per PivotField allowed.
XlPivotTableSourceTypeSpecifies the source of the report data.
XlPivotTableVersionListSpecifies the Microsoft Excel version number.
XlPlacementSpecifies the way an object is attached to its underlying cells.
XlPlatformSpecifies the platform that a text file originated on.
XlPrintErrorsSpecifies the type of print error displayed.
XlPrintLocationSpecifies the way comments are printed with the sheet.
XlPrioritySpecifies the priority of a SendMailer message.
XlPTSelectionModeSpecifies what may be selected in a PivotTable during a structured selection. These constants may be combined to select multiple types.
XlQueryTypeSpecifies the type of query used by Microsoft Excel to populate the query table or PivotTable cache.
XlRangeAutoFormatSpecifies the predefined format when a range is automatically formatted.
XlRangeValueDataTypeSpecifies the range value data type.
XlReferenceStyleSpecifies the reference style.
XlReferenceTypeSpecifies cell reference style when a formula is being converted.
XlRobustConnectSpecifies how the PivotTable cache connects to its data source.
XlRoutingSlipDeliverySpecifies the routing delivery method.
XlRoutingSlipStatusSpecifies the status of the routing slip.
XlRowColSpecifies whether the values corresponding to a particular data series are in rows or columns.
XlRunAutoMacroSpecifies the automatic macro to run.
XlSaveActionSpecifies during file close if the file will be saved.
XlSaveAsAccessModeSpecifies the access mode for the Save As function.
XlSaveConflictResolutionSpecifies the way conflicts are to be resolved whenever a shared workbook is updated.
XlScaleTypeSpecifies the scale type of the value axis.
XlSearchDirectionSpecifies the search direction when searching a range.
XlSearchOrderSpecifies the order in which to search the range.
XlSearchWithinSpecifies the extent of the search for the range.
XlSheetTypeSpecifies the worksheet type.
XlSheetVisibilitySpecifies whether the object is visible.
XlSizeRepresentsSpecifies what the bubble size represents on a bubble chart.
XlSmartTagControlTypeSpecifies the type of Smart Document control displayed in the Document Actions task pane.
XlSmartTagDisplayModeSpecifies the display features for smart tags.
XlSortDataOptionSpecifies how to sort text.
XlSortMethodSpecifies the type of sort.
XlSortMethodOldSpecifies how to sort when using East Asian sorting methods.
XlSortOrderSpecifies the sort order for the specified field or range.
XlSortOrientationSpecifies the sort orientation.
XlSortTypeSpecifies which elements are to be sorted. Use this argument only when sorting PivotTable reports.
XlSourceTypeIdentifies the source object.
XlSpeakDirectionSpecifies the order in which the cells are spoken.
XlSpecialCellsValueSpecifies cells with a particular type of value to include in the result.
XlSubscribeToFormatSpecifies the format to use when subscribing to a published edition.
XlSubtototalLocationTypeSpecifies where the subtotal will be displayed on the worksheet.
XlSummaryColumnSpecifies the location of the summary columns in the outline.
XlSummaryReportTypeSpecifies the type of summary to be created for scenarios.
XlSummaryRowSpecifies the location of the summary rows in the outline.
XlTabPositionSpecifies the first or last tab position.
XlTextParsingTypeSpecifies the column format for the data in the text file that you’re importing into a query table.
XlTextQualifierSpecifies the delimiter to use to specify text.
XlTextVisualLayoutTypeSpecifies whether the visual layout of the text being imported is left-to-right or right-to-left.
XlTickLabelOrientationSpecifies the text orientation for tick-mark labels.
XlTickLabelPositionSpecifies the position of tick-mark labels on the specified axis.
XlTickMarkSpecifies the position of major and minor tick marks for an axis.
XlTimeUnitSpecifies unit of time for chart axis and data series.
XlToolbarProtectionSpecifies which properties of a toolbar are restricted. Options may be combined using Or.
XlTotalsCalculationSpecifies the type of calculation in the Totals row of a list column.
XlTrendlineTypeSpecifies how the trendline that smoothes out fluctuations in the data is calculated.
XlUnderlineStyleSpecifies the type of underline applied to a font.
XlUpdateLinksSpecifies a workbook's setting for updating embedded OLE links.
XlVAlignSpecifies the vertical alignment for the object.
XlWBATemplateSpecifies the type of workbook to create.
XlWebFormattingSpecifies how much formatting from a Web page, if any, is applied when a Web page is imported into a query table.
XlWebSelectionTypeSpecifies whether an entire Web page, all tables on the Web page, or only a specific table is imported into a query table.
XlWindowStateSpecifies the state of the window.
XlWindowTypeSpecifies how the chart is displayed.
XlWindowViewSpecifies the view showing in the window.
XlXLMMacroTypeSpecifies, in a Microsoft Excel version 4 macro worksheet, what type of macro a name refers to or whether the name refers to a macro.
XlXmlExportResultSpecifies the results of the save or export operation.
XlXmlImportResultSpecifies the results of the refresh or import operation.
XlXmlLoadOptionSpecifies how Excel opens the XML data file.
XlYesNoGuessSpecifies whether or not the first row contains headers.

Community Additions

ADD
Show:
© 2014 Microsoft