TOC.md

#Excel VBA reference ##Concepts ###About the PowerPivot Model Object in Excel ###Language-specific Properties, Methods, and Functions ###OLE DB for OLAP Properties Used by Excel ###Programming for the Single Document Interface in Excel ###Functions ####Using the Solver VBA Functions ####SolverAdd Function ####SolverChange Function ####SolverDelete Function ####SolverFinish Function ####SolverFinishDialog Function ####SolverGet Function ####SolverLoad Function ####SolverOk Function ####SolverOkDialog Function ####SolverOptions Function ####SolverReset Function ####SolverSave Function ####SolverSolve Function ###Workbooks and Worksheets ####Opening a Workbook ####Saving Documents as Web Pages ####Formatting and VBA Codes for Headers and Footers ####Returning an Object from a Collection ###Cells and Ranges ####Looping Through a Range of Cells ####Selecting and Activating Cells ####Working with 3-D Ranges ####Working with the Active Cell ####Cell Error Values ###Controls, Dialog Boxes, and Forms ####ActiveX Controls ####Using ActiveX Controls on Sheets ####Using ActiveX Controls on a Document ####Built-In Dialog Box Argument Lists ####Using Control Values While Code Is Running ####Displaying a Custom Dialog Box ####Initializing Control Properties ####Setting Control Properties ###Events, Worksheet Functions, and Shapes ####Chart Object Events ####Control and Dialog Box Events ####QueryTable Object Events ####Worksheet Object Events ####Using Events with Excel Objects ####Using Excel Worksheet Functions in Visual Basic ####Working with Shapes (Drawing Objects) ####List of Worksheet Functions Available to Visual Basic ####List of Worksheet Functions that Support Long Strings ####Using Events with Embedded Charts ####Using Events with the Application Object ####Using Events with the QueryTable Object ####Invalid Procedure Name Error ###Working with Other Applications ####Controlling One Microsoft Office Application from Another ####Exporting a Chart to a Word Document ####Exporting a Range to a Table in a Word Document ####Exporting a Table to a Word Document ####Import Outlook Contacts to a Worksheet ####Sending Email to a List of Recipients Using Excel and Outlook ##How do I... ###Workbooks and Worksheets ####Add a Table of Contents to a Workbook ####Create Address Labels from a Spreadsheet ####Create a Scheduling Calendar Workbook ####Create a Workbook ####Create or Replace a Worksheet ####Name a Worksheet By Using a Cell Value ####Refer to More Than One Sheet ####Refer to Sheets by Index Number ####Refer to Sheets by Name ####Sort Worksheets Alphanumerically by Name ###Cells and Ranges ####Create an HTML File with a Table of Contents based on Cell Data ####Delete Duplicate Entries in a Range ####Fill a Value Down into Blank Cells in a Column ####Hide and Unhide Columns ####Highlight the Active Cell, Row, or Column ####Make a Cell Blink ####Prevent Duplicate Entries in a Range ####Reference Cells and Ranges ####Refer to All the Cells on the Worksheet ####Refer to Cells and Ranges by Using A1 Notation ####Refer to Cells by Using a Range Object ####Refer to Cells by Using Index Numbers ####Refer to Cells by Using Shortcut Notation ####Refer to Cells Relative to Other Cells ####Refer to Multiple Ranges ####Refer to Named Ranges ####Refer to Rows and Columns ####Select a Range ###Controls, Dialog Boxes, and Forms ####Add a Unique List of Values to a Combo Box ####Add Controls to a Document ####Add Controls to a User Form ####Automatically Dismiss a Message Box ####Create a Custom Dialog Box ####Create a Custom Menu That Calls a Macro ####Create a User Form ###Sparklines ####Animate a Sparkline ####Change the Color of the Horizontal Axis of a Sparkline ####Find All the Sparklines on a Sheet ##Object model ###AboveAverage Object ####AboveBelow Property ####Application Property ####AppliesTo Property ####Borders Property ####CalcFor Property ####Creator Property ####Font Property ####Interior Property ####NumberFormat Property ####NumStdDev Property ####Parent Property ####Priority Property ####PTCondition Property ####ScopeType Property ####StopIfTrue Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###Action Object ####Application Property ####Caption Property ####Content Property ####Coordinate Property ####Creator Property ####Name Property ####Parent Property ####Type Property ####Execute Method ###Actions Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###AddIn Object ####Application Property ####CLSID Property ####Creator Property ####FullName Property ####Installed Property ####IsOpen Property ####Name Property ####Parent Property ####Path Property ####progID Property ###AddIns Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###AddIns2 Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###Adjustments Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###AllowEditRange Object ####Range Property ####Title Property ####Users Property ####ChangePassword Method ####Delete Method ####Unprotect Method ###AllowEditRanges Object ####Count Property ####Item Property ####Add Method ###Application Object ####ActiveCell Property ####ActiveChart Property ####ActiveEncryptionSession Property ####ActivePrinter Property ####ActiveProtectedViewWindow Property ####ActiveSheet Property ####ActiveWindow Property ####ActiveWorkbook Property ####AddIns Property ####AddIns2 Property ####AlertBeforeOverwriting Property ####AltStartupPath Property ####AlwaysUseClearType Property ####Application Property ####ArbitraryXMLSupportAvailable Property ####AskToUpdateLinks Property ####Assistance Property ####AutoCorrect Property ####AutoFormatAsYouTypeReplaceHyperlinks Property ####AutomationSecurity Property ####AutoPercentEntry Property ####AutoRecover Property ####Build Property ####CalculateBeforeSave Property ####Calculation Property ####CalculationInterruptKey Property ####CalculationState Property ####CalculationVersion Property ####Caller Property ####CanPlaySounds Property ####CanRecordSounds Property ####Caption Property ####CellDragAndDrop Property ####Cells Property ####ChartDataPointTrack Property ####Charts Property ####ClipboardFormats Property ####ClusterConnector Property ####Columns Property ####COMAddIns Property ####CommandBars Property ####CommandUnderlines Property ####ConstrainNumeric Property ####ControlCharacters Property ####CopyObjectsWithCells Property ####Creator Property ####Cursor Property ####CursorMovement Property ####CustomListCount Property ####CutCopyMode Property ####DataEntryMode Property ####DDEAppReturnCode Property ####DecimalSeparator Property ####DefaultFilePath Property ####DefaultSaveFormat Property ####DefaultSheetDirection Property ####DefaultWebOptions Property ####DeferAsyncQueries Property ####Dialogs Property ####DisplayAlerts Property ####DisplayClipboardWindow Property ####DisplayCommentIndicator Property ####DisplayDocumentActionTaskPane Property ####DisplayDocumentInformationPanel Property ####DisplayExcel4Menus Property ####DisplayFormulaAutoComplete Property ####DisplayFormulaBar Property ####DisplayFullScreen Property ####DisplayFunctionToolTips Property ####DisplayInsertOptions Property ####DisplayNoteIndicator Property ####DisplayPasteOptions Property ####DisplayRecentFiles Property ####DisplayScrollBars Property ####DisplayStatusBar Property ####EditDirectlyInCell Property ####EnableAnimations Property ####EnableAutoComplete Property ####EnableCancelKey Property ####EnableCheckFileExtensions Property ####EnableEvents Property ####EnableLargeOperationAlert Property ####EnableLivePreview Property ####EnableMacroAnimations Property ####EnableSound Property ####ErrorCheckingOptions Property ####Excel4IntlMacroSheets Property ####Excel4MacroSheets Property ####ExtendList Property ####FeatureInstall Property ####FileConverters Property ####FileDialog Property ####FileExportConverters Property ####FileValidation Property ####FileValidationPivot Property ####FindFormat Property ####FixedDecimal Property ####FixedDecimalPlaces Property ####FlashFill Property ####FlashFillMode Property ####FormulaBarHeight Property ####GenerateGetPivotData Property ####GenerateTableRefs Property ####Height Property ####HighQualityModeForGraphics Property ####Hinstance Property ####HinstancePtr Property ####Hwnd Property ####IgnoreRemoteRequests Property ####Interactive Property ####International Property ####IsSandboxed Property ####Iteration Property ####LanguageSettings Property ####LargeOperationCellThousandCount Property ####Left Property ####LibraryPath Property ####MailSession Property ####MailSystem Property ####MapPaperSize Property ####MathCoprocessorAvailable Property ####MaxChange Property ####MaxIterations Property ####MeasurementUnit Property ####MergeInstances Property ####MouseAvailable Property ####MoveAfterReturn Property ####MoveAfterReturnDirection Property ####MultiThreadedCalculation Property ####Name Property ####Names Property ####NetworkTemplatesPath Property ####NewWorkbook Property ####ODBCErrors Property ####ODBCTimeout Property ####OLEDBErrors Property ####OnWindow Property ####OperatingSystem Property ####OrganizationName Property ####Parent Property ####Path Property ####PathSeparator Property ####PivotTableSelection Property ####PreviousSelections Property ####PrintCommunication Property ####ProductCode Property ####PromptForSummaryInfo Property ####ProtectedViewWindows Property ####QuickAnalysis Property ####Range Property ####Ready Property ####RecentFiles Property ####RecordRelative Property ####ReferenceStyle Property ####RegisteredFunctions Property ####ReplaceFormat Property ####RollZoom Property ####Rows Property ####RTD Property ####ScreenUpdating Property ####Selection Property ####Sheets Property ####SheetsInNewWorkbook Property ####ShowChartTipNames Property ####ShowChartTipValues Property ####ShowDevTools Property ####ShowMenuFloaties Property ####ShowQuickAnalysis Property ####ShowSelectionFloaties Property ####ShowStartupDialog Property ####ShowToolTips Property ####SmartArtColors Property ####SmartArtLayouts Property ####SmartArtQuickStyles Property ####Speech Property ####SpellingOptions Property ####StandardFont Property ####StandardFontSize Property ####StartupPath Property ####StatusBar Property ####TemplatesPath Property ####ThisCell Property ####ThisWorkbook Property ####ThousandsSeparator Property ####Top Property ####TransitionMenuKey Property ####TransitionMenuKeyAction Property ####TransitionNavigKeys Property ####UsableHeight Property ####UsableWidth Property ####UseClusterConnector Property ####UsedObjects Property ####UserControl Property ####UserLibraryPath Property ####UserName Property ####UseSystemSeparators Property ####Value Property ####VBE Property ####Version Property ####Visible Property ####WarnOnFunctionNameConflict Property ####Watches Property ####Width Property ####Windows Property ####WindowsForPens Property ####WindowState Property ####Workbooks Property ####WorksheetFunction Property ####Worksheets Property ####ActivateMicrosoftApp Method ####AddCustomList Method ####Calculate Method ####CalculateFull Method ####CalculateFullRebuild Method ####CalculateUntilAsyncQueriesDone Method ####CentimetersToPoints Method ####CheckAbort Method ####CheckSpelling Method ####ConvertFormula Method ####DDEExecute Method ####DDEInitiate Method ####DDEPoke Method ####DDERequest Method ####DDETerminate Method ####DeleteCustomList Method ####DisplayXMLSourcePane Method ####DoubleClick Method ####Evaluate Method ####ExecuteExcel4Macro Method ####FindFile Method ####GetCustomListContents Method ####GetCustomListNum Method ####GetOpenFilename Method ####GetPhonetic Method ####GetSaveAsFilename Method ####Goto Method ####Help Method ####InchesToPoints Method ####InputBox Method ####Intersect Method ####MacroOptions Method ####MailLogoff Method ####MailLogon Method ####NextLetter Method ####OnKey Method ####OnRepeat Method ####OnTime Method ####OnUndo Method ####Quit Method ####RecordMacro Method ####RegisterXLL Method ####Repeat Method ####SaveWorkspace Method ####Run Method ####SendKeys Method ####SharePointVersion Method ####Undo Method ####Union Method ####Volatile Method ####Wait Method ####AfterCalculate Event ####NewWorkbook Event ####ProtectedViewWindowActivate Event ####ProtectedViewWindowBeforeClose Event ####ProtectedViewWindowBeforeEdit Event ####ProtectedViewWindowDeactivate Event ####ProtectedViewWindowOpen Event ####ProtectedViewWindowResize Event ####SheetActivate Event ####SheetBeforeDelete Event ####SheetBeforeDoubleClick Event ####SheetBeforeRightClick Event ####SheetCalculate Event ####SheetChange Event ####SheetDeactivate Event ####SheetFollowHyperlink Event ####SheetLensGalleryRenderComplete Event ####SheetPivotTableAfterValueChange Event ####SheetPivotTableBeforeAllocateChanges Event ####SheetPivotTableBeforeCommitChanges Event ####SheetPivotTableBeforeDiscardChanges Event ####SheetPivotTableUpdate Event ####SheetSelectionChange Event ####SheetTableUpdate Event ####WindowActivate Event ####WindowDeactivate Event ####WindowResize Event ####WorkbookActivate Event ####WorkbookAddinInstall Event ####WorkbookAddinUninstall Event ####WorkbookAfterSave Event ####WorkbookAfterXmlExport Event ####WorkbookAfterXmlImport Event ####WorkbookBeforeClose Event ####WorkbookBeforePrint Event ####WorkbookBeforeSave Event ####WorkbookBeforeXmlExport Event ####WorkbookBeforeXmlImport Event ####WorkbookDeactivate Event ####WorkbookModelChange Event ####WorkbookNewChart Event ####WorkbookNewSheet Event ####WorkbookOpen Event ####WorkbookPivotTableCloseConnection Event ####WorkbookPivotTableOpenConnection Event ####WorkbookRowsetComplete Event ####WorkbookSync Event ###Areas Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###AutoCorrect Object ####Application Property ####AutoExpandListRange Property ####AutoFillFormulasInLists Property ####CapitalizeNamesOfDays Property ####CorrectCapsLock Property ####CorrectSentenceCap Property ####Creator Property ####DisplayAutoCorrectOptions Property ####Parent Property ####ReplacementList Property ####ReplaceText Property ####TwoInitialCapitals Property ####AddReplacement Method ####DeleteReplacement Method ###AutoFilter Object ####Application Property ####Creator Property ####FilterMode Property ####Filters Property ####Parent Property ####Range Property ####Sort Property ####ApplyFilter Method ####ShowAllData Method ###AutoRecover Object ####Application Property ####Creator Property ####Enabled Property ####Parent Property ####Path Property ####Time Property ###Axes Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###Axis Object ####Application Property ####AxisBetweenCategories Property ####AxisGroup Property ####AxisTitle Property ####BaseUnit Property ####BaseUnitIsAuto Property ####Border Property ####CategoryNames Property ####CategoryType Property ####Creator Property ####Crosses Property ####CrossesAt Property ####DisplayUnit Property ####DisplayUnitCustom Property ####DisplayUnitLabel Property ####Format Property ####HasDisplayUnitLabel Property ####HasMajorGridlines Property ####HasMinorGridlines Property ####HasTitle Property ####Height Property ####Left Property ####LogBase Property ####MajorGridlines Property ####MajorTickMark Property ####MajorUnit Property ####MajorUnitIsAuto Property ####MajorUnitScale Property ####MaximumScale Property ####MaximumScaleIsAuto Property ####MinimumScale Property ####MinimumScaleIsAuto Property ####MinorGridlines Property ####MinorTickMark Property ####MinorUnit Property ####MinorUnitIsAuto Property ####MinorUnitScale Property ####Parent Property ####ReversePlotOrder Property ####ScaleType Property ####TickLabelPosition Property ####TickLabels Property ####TickLabelSpacing Property ####TickLabelSpacingIsAuto Property ####TickMarkSpacing Property ####Top Property ####Type Property ####Width Property ####Delete Method ####Select Method ###AxisTitle Object ####Application Property ####Caption Property ####Characters Property ####Creator Property ####Format Property ####Formula Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####Height Property ####HorizontalAlignment Property ####IncludeInLayout Property ####Left Property ####Name Property ####Orientation Property ####Parent Property ####Position Property ####ReadingOrder Property ####Shadow Property ####Text Property ####Top Property ####VerticalAlignment Property ####Width Property ####Delete Method ####Select Method ###Border Object ####Application Property ####Color Property ####ColorIndex Property ####Creator Property ####LineStyle Property ####Parent Property ####ThemeColor Property ####TintAndShade Property ####Weight Property ###Borders Object ####Application Property ####Color Property ####ColorIndex Property ####Count Property ####Creator Property ####Item Property ####LineStyle Property ####Parent Property ####ThemeColor Property ####TintAndShade Property ####Value Property ####Weight Property ###CalculatedFields Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###CalculatedItems Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###CalculatedMember Object ####Application Property ####Creator Property ####DisplayFolder Property ####Dynamic Property ####FlattenHierarchies Property ####Formula Property ####HierarchizeDistinct Property ####IsValid Property ####MeasureGroup Property ####Name Property ####NumberFormat Property ####Parent Property ####ParentHierarchy Property ####ParentMember Property ####SolveOrder Property ####SourceName Property ####Type Property ####Delete Method ###CalculatedMembers Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####AddCalculatedMember Method ###CalloutFormat Object ####Accent Property ####Angle Property ####Application Property ####AutoAttach Property ####AutoLength Property ####Border Property ####Creator Property ####Drop Property ####DropType Property ####Gap Property ####Length Property ####Parent Property ####Type Property ####AutomaticLength Method ####CustomDrop Method ####CustomLength Method ####PresetDrop Method ###CategoryCollection Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###CellFormat Object ####AddIndent Property ####Application Property ####Borders Property ####Creator Property ####Font Property ####FormulaHidden Property ####HorizontalAlignment Property ####IndentLevel Property ####Interior Property ####Locked Property ####MergeCells Property ####NumberFormat Property ####NumberFormatLocal Property ####Orientation Property ####Parent Property ####ShrinkToFit Property ####VerticalAlignment Property ####WrapText Property ####Clear Method ###Characters Object ####Application Property ####Caption Property ####Count Property ####Creator Property ####Font Property ####Parent Property ####PhoneticCharacters Property ####Text Property ####Delete Method ####Insert Method ###Chart Object ####Application Property ####AutoScaling Property ####BackWall Property ####BarShape Property ####CategoryLabelLevel Property ####ChartArea Property ####ChartColor Property ####ChartStyle Property ####ChartTitle Property ####ChartType Property ####CodeName Property ####Creator Property ####DataTable Property ####DepthPercent Property ####DisplayBlanksAs Property ####Elevation Property ####Floor Property ####GapDepth Property ####HasAxis Property ####HasDataTable Property ####HasLegend Property ####HasTitle Property ####HeightPercent Property ####Hyperlinks Property ####Index Property ####Legend Property ####MailEnvelope Property ####Name Property ####Next Property ####PageSetup Property ####Parent Property ####Perspective Property ####PivotLayout Property ####PlotArea Property ####PlotBy Property ####PlotVisibleOnly Property ####Previous Property ####PrintedCommentPages Property ####ProtectContents Property ####ProtectData Property ####ProtectDrawingObjects Property ####ProtectFormatting Property ####ProtectionMode Property ####ProtectSelection Property ####RightAngleAxes Property ####Rotation Property ####SeriesNameLevel Property ####Shapes Property ####ShowAllFieldButtons Property ####ShowAxisFieldButtons Property ####ShowDataLabelsOverMaximum Property ####ShowExpandCollapseEntireFieldButtons Property ####ShowLegendFieldButtons Property ####ShowReportFilterFieldButtons Property ####ShowValueFieldButtons Property ####SideWall Property ####Tab Property ####Visible Property ####Walls Property ####Activate Method ####ApplyChartTemplate Method ####ApplyDataLabels Method ####ApplyLayout Method ####Axes Method ####ChartGroups Method ####ChartObjects Method ####ChartWizard Method ####CheckSpelling Method ####ClearToMatchColorStyle Method ####ClearToMatchStyle Method ####Copy Method ####CopyPicture Method ####Delete Method ####Evaluate Method ####Export Method ####ExportAsFixedFormat Method ####FullSeriesCollection Method ####GetChartElement Method ####Location Method ####Move Method ####OLEObjects Method ####Paste Method ####PrintOut Method ####PrintPreview Method ####Protect Method ####Refresh Method ####SaveAs Method ####SaveChartTemplate Method ####Select Method ####SeriesCollection Method ####SetBackgroundPicture Method ####SetDefaultChart Method ####SetElement Method ####SetSourceData Method ####Unprotect Method ####Activate Event ####BeforeDoubleClick Event ####BeforeRightClick Event ####Calculate Event ####Deactivate Event ####MouseDown Event ####MouseMove Event ####MouseUp Event ####Resize Event ####Select Event ####SeriesChange Event ###ChartArea Object ####Application Property ####Creator Property ####Format Property ####Height Property ####Left Property ####Name Property ####Parent Property ####RoundedCorners Property ####Shadow Property ####Top Property ####Width Property ####Clear Method ####ClearContents Method ####ClearFormats Method ####Copy Method ####Select Method ###ChartCategory Object ####Application Property ####Creator Property ####IsFiltered Property ####Name Property ####Parent Property ###ChartFormat Object ####Adjustments Property ####Application Property ####AutoShapeType Property ####Creator Property ####Fill Property ####Glow Property ####Line Property ####Parent Property ####PictureFormat Property ####Shadow Property ####SoftEdge Property ####TextFrame2 Property ####ThreeD Property ###ChartGroup Object ####Application Property ####AxisGroup Property ####BinsCountValue Property ####BinsOverflowEnabled Property ####BinsOverflowValue Property ####BinsType Property ####BinsUnderflowEnabled Property ####BinsUnderflowValue Property ####BinWidthValue Property ####BubbleScale Property ####Creator Property ####DoughnutHoleSize Property ####DownBars Property ####DropLines Property ####FirstSliceAngle Property ####GapWidth Property ####Has3DShading Property ####HasDropLines Property ####HasHiLoLines Property ####HasRadarAxisLabels Property ####HasSeriesLines Property ####HasUpDownBars Property ####HiLoLines Property ####Index Property ####Overlap Property ####Parent Property ####RadarAxisLabels Property ####SecondPlotSize Property ####SeriesLines Property ####ShowNegativeBubbles Property ####SizeRepresents Property ####SplitType Property ####SplitValue Property ####UpBars Property ####VaryByCategories Property ####CategoryCollection Method ####FullCategoryCollection Method ####SeriesCollection Method ###ChartGroups Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ChartObject Object ####Application Property ####BottomRightCell Property ####Chart Property ####Creator Property ####Height Property ####Index Property ####Left Property ####Locked Property ####Name Property ####Parent Property ####Placement Property ####PrintObject Property ####ProtectChartObject Property ####RoundedCorners Property ####Shadow Property ####ShapeRange Property ####Top Property ####TopLeftCell Property ####Visible Property ####Width Property ####ZOrder Property ####Activate Method ####BringToFront Method ####Copy Method ####CopyPicture Method ####Cut Method ####Delete Method ####Duplicate Method ####Select Method ####SendToBack Method ###ChartObjects Object ####Application Property ####Count Property ####Creator Property ####Height Property ####Left Property ####Locked Property ####Parent Property ####Placement Property ####PrintObject Property ####ProtectChartObject Property ####ShapeRange Property ####Top Property ####Visible Property ####Width Property ####Add Method ####Copy Method ####CopyPicture Method ####Cut Method ####Delete Method ####Duplicate Method ####Item Method ####Select Method ###Charts Object ####Application Property ####Count Property ####Creator Property ####HPageBreaks Property ####Item Property ####Parent Property ####Visible Property ####VPageBreaks Property ####Add2 Method ####Copy Method ####Delete Method ####Move Method ####PrintOut Method ####PrintPreview Method ####Select Method ###ChartTitle Object ####Application Property ####Caption Property ####Characters Property ####Creator Property ####Format Property ####Formula Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####Height Property ####HorizontalAlignment Property ####IncludeInLayout Property ####Left Property ####Name Property ####Orientation Property ####Parent Property ####Position Property ####ReadingOrder Property ####Shadow Property ####Text Property ####Top Property ####VerticalAlignment Property ####Width Property ####Delete Method ####Select Method ###ChartView Object ####Application Property ####Creator Property ####Parent Property ####Sheet Property ###ColorFormat Object ####Application Property ####Brightness Property ####Creator Property ####ObjectThemeColor Property ####Parent Property ####RGB Property ####SchemeColor Property ####TintAndShade Property ####Type Property ###ColorScale Object ####Application Property ####AppliesTo Property ####ColorScaleCriteria Property ####Creator Property ####Formula Property ####Parent Property ####Priority Property ####PTCondition Property ####ScopeType Property ####StopIfTrue Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###ColorScaleCriteria Object ####Count Property ####Item Property ###ColorScaleCriterion Object ####FormatColor Property ####Index Property ####Type Property ####Value Property ###ColorStop Object ####Application Property ####Color Property ####Creator Property ####Parent Property ####Position Property ####ThemeColor Property ####TintAndShade Property ####Delete Method ###ColorStops Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Clear Method ####Item Method ###Comment Object ####Application Property ####Author Property ####Creator Property ####Parent Property ####Shape Property ####Visible Property ####Delete Method ####Next Method ####Previous Method ####Text Method ###Comments Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ConditionValue Object ####Application Property ####Creator Property ####Parent Property ####Type Property ####Value Property ####Modify Method ###Connections Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####AddFromFile Method ####Item Method ###ConnectorFormat Object ####Application Property ####BeginConnected Property ####BeginConnectedShape Property ####BeginConnectionSite Property ####Creator Property ####EndConnected Property ####EndConnectedShape Property ####EndConnectionSite Property ####Parent Property ####Type Property ####BeginConnect Method ####BeginDisconnect Method ####EndConnect Method ####EndDisconnect Method ###ControlFormat Object ####Application Property ####Creator Property ####DropDownLines Property ####Enabled Property ####LargeChange Property ####LinkedCell Property ####ListCount Property ####ListFillRange Property ####ListIndex Property ####LockedText Property ####Max Property ####Min Property ####MultiSelect Property ####Parent Property ####PrintObject Property ####SmallChange Property ####Value Property ####AddItem Method ####List Method ####RemoveAllItems Method ####RemoveItem Method ###CubeField Object ####AllItemsVisible Property ####Application Property ####Caption Property ####Creator Property ####CubeFieldSubType Property ####CubeFieldType Property ####CurrentPageName Property ####DragToColumn Property ####DragToData Property ####DragToHide Property ####DragToPage Property ####DragToRow Property ####EnableMultiplePageItems Property ####FlattenHierarchies Property ####HasMemberProperties Property ####HierarchizeDistinct Property ####IncludeNewItemsInFilter Property ####IsDate Property ####LayoutForm Property ####LayoutSubtotalLocation Property ####Name Property ####Orientation Property ####Parent Property ####PivotFields Property ####Position Property ####ShowInFieldList Property ####TreeviewControl Property ####Value Property ####AddMemberPropertyField Method ####AutoGroup Method ####ClearManualFilter Method ####CreatePivotFields Method ####Delete Method ###CubeFields Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####AddSet Method ####GetMeasure Method ###CustomProperties Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###CustomProperty Object ####Application Property ####Creator Property ####Name Property ####Parent Property ####Value Property ####Delete Method ###CustomView Object ####Application Property ####Creator Property ####Name Property ####Parent Property ####PrintSettings Property ####RowColSettings Property ####Delete Method ####Show Method ###CustomViews Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###Databar Object ####Application Property ####AppliesTo Property ####AxisColor Property ####AxisPosition Property ####BarBorder Property ####BarColor Property ####BarFillType Property ####Creator Property ####Direction Property ####Formula Property ####MaxPoint Property ####MinPoint Property ####NegativeBarFormat Property ####Parent Property ####PercentMax Property ####PercentMin Property ####Priority Property ####PTCondition Property ####ScopeType Property ####ShowValue Property ####StopIfTrue Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###DataBarBorder Object ####Application Property ####Color Property ####Creator Property ####Parent Property ####Type Property ###DataFeedConnection Object ####AlwaysUseConnectionFile Property ####Application Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####EnableRefresh Property ####Parent Property ####RefreshDate Property ####Refreshing Property ####RefreshOnFileOpen Property ####RefreshPeriod Property ####SavePassword Property ####ServerCredentialsMethod Property ####SourceConnectionFile Property ####SourceDataFile Property ####CancelRefresh Method ####Refresh Method ####SaveAsODC Method ###DataLabel Object ####Application Property ####AutoText Property ####Caption Property ####Characters Property ####Creator Property ####Format Property ####Formula Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####Height Property ####HorizontalAlignment Property ####Left Property ####Name Property ####NumberFormat Property ####NumberFormatLinked Property ####NumberFormatLocal Property ####Orientation Property ####Parent Property ####Position Property ####ReadingOrder Property ####Separator Property ####Shadow Property ####ShowBubbleSize Property ####ShowCategoryName Property ####ShowLegendKey Property ####ShowPercentage Property ####ShowRange Property ####ShowSeriesName Property ####ShowValue Property ####Text Property ####Top Property ####VerticalAlignment Property ####Width Property ####Delete Method ####Select Method ###DataLabels Object ####Application Property ####AutoText Property ####Count Property ####Creator Property ####Format Property ####HorizontalAlignment Property ####Name Property ####NumberFormat Property ####NumberFormatLinked Property ####NumberFormatLocal Property ####Orientation Property ####Parent Property ####Position Property ####ReadingOrder Property ####Separator Property ####Shadow Property ####ShowBubbleSize Property ####ShowCategoryName Property ####ShowLegendKey Property ####ShowPercentage Property ####ShowRange Property ####ShowSeriesName Property ####ShowValue Property ####VerticalAlignment Property ####Delete Method ####Item Method ####Propagate Method ####Select Method ###DataTable Object ####Application Property ####Border Property ####Creator Property ####Font Property ####Format Property ####HasBorderHorizontal Property ####HasBorderOutline Property ####HasBorderVertical Property ####Parent Property ####ShowLegendKey Property ####Delete Method ####Select Method ###DefaultWebOptions Object ####AllowPNG Property ####AlwaysSaveInDefaultEncoding Property ####Application Property ####CheckIfOfficeIsHTMLEditor Property ####Creator Property ####DownloadComponents Property ####Encoding Property ####FolderSuffix Property ####Fonts Property ####LoadPictures Property ####LocationOfComponents Property ####OrganizeInFolder Property ####Parent Property ####PixelsPerInch Property ####RelyOnCSS Property ####RelyOnVML Property ####SaveHiddenData Property ####SaveNewWebPagesAsWebArchives Property ####ScreenSize Property ####TargetBrowser Property ####UpdateLinksOnSave Property ####UseLongFileNames Property ###Dialog Object ####Application Property ####Creator Property ####Parent Property ####Show Method ###Dialogs Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###DialogSheetView Object ####Application Property ####Creator Property ####Parent Property ####Sheet Property ###DisplayFormat Object ####AddIndent Property ####Application Property ####Borders Property ####Characters Property ####Creator Property ####Font Property ####FormulaHidden Property ####HorizontalAlignment Property ####IndentLevel Property ####Interior Property ####Locked Property ####MergeCells Property ####NumberFormat Property ####NumberFormatLocal Property ####Orientation Property ####Parent Property ####ReadingOrder Property ####ShrinkToFit Property ####Style Property ####VerticalAlignment Property ####WrapText Property ###DisplayUnitLabel Object ####Application Property ####Caption Property ####Characters Property ####Creator Property ####Format Property ####Formula Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####Height Property ####HorizontalAlignment Property ####Left Property ####Name Property ####Orientation Property ####Parent Property ####Position Property ####ReadingOrder Property ####Shadow Property ####Text Property ####Top Property ####VerticalAlignment Property ####Width Property ####Delete Method ####Select Method ###DownBars Object ####Application Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###DropLines Object ####Application Property ####Border Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###Error Object ####Application Property ####Creator Property ####Ignore Property ####Parent Property ####Value Property ###ErrorBars Object ####Application Property ####Border Property ####Creator Property ####EndStyle Property ####Format Property ####Name Property ####Parent Property ####ClearFormats Method ####Delete Method ####Select Method ###ErrorCheckingOptions Object ####Application Property ####BackgroundChecking Property ####Creator Property ####EmptyCellReferences Property ####EvaluateToError Property ####InconsistentFormula Property ####InconsistentTableFormula Property ####IndicatorColorIndex Property ####ListDataValidation Property ####NumberAsText Property ####OmittedCells Property ####Parent Property ####TextDate Property ####UnlockedFormulaCells Property ###Errors Object ####Application Property ####Creator Property ####Item Property ####Parent Property ###FileExportConverter Object ####Application Property ####Creator Property ####Description Property ####Extensions Property ####FileFormat Property ####Parent Property ###FileExportConverters Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###FillFormat Object ####Application Property ####BackColor Property ####Creator Property ####ForeColor Property ####GradientAngle Property ####GradientColorType Property ####GradientDegree Property ####GradientStops Property ####GradientStyle Property ####GradientVariant Property ####Parent Property ####Pattern Property ####PictureEffects Property ####PresetGradientType Property ####PresetTexture Property ####RotateWithObject Property ####TextureAlignment Property ####TextureHorizontalScale Property ####TextureName Property ####TextureOffsetX Property ####TextureOffsetY Property ####TextureTile Property ####TextureType Property ####TextureVerticalScale Property ####Transparency Property ####Type Property ####Visible Property ####OneColorGradient Method ####Patterned Method ####PresetGradient Method ####PresetTextured Method ####Solid Method ####TwoColorGradient Method ####UserPicture Method ####UserTextured Method ###Filter Object ####Application Property ####Count Property ####Creator Property ####Criteria1 Property ####Criteria2 Property ####On Property ####Operator Property ####Parent Property ###Filters Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###Floor Object ####Application Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####PictureType Property ####Thickness Property ####ClearFormats Method ####Paste Method ####Select Method ###Font Object ####Application Property ####Background Property ####Bold Property ####Color Property ####ColorIndex Property ####Creator Property ####FontStyle Property ####Italic Property ####Name Property ####Parent Property ####Size Property ####Strikethrough Property ####Subscript Property ####Superscript Property ####ThemeColor Property ####ThemeFont Property ####TintAndShade Property ####Underline Property ###FormatColor Object ####Application Property ####Color Property ####ColorIndex Property ####Creator Property ####Parent Property ####ThemeColor Property ####TintAndShade Property ###FormatCondition Object ####Application Property ####AppliesTo Property ####Borders Property ####Creator Property ####DateOperator Property ####Font Property ####Formula1 Property ####Formula2 Property ####Interior Property ####NumberFormat Property ####Operator Property ####Parent Property ####Priority Property ####PTCondition Property ####ScopeType Property ####StopIfTrue Property ####Text Property ####TextOperator Property ####Type Property ####Delete Method ####Modify Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###FormatConditions Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####AddAboveAverage Method ####AddColorScale Method ####AddDatabar Method ####AddIconSetCondition Method ####AddTop10 Method ####AddUniqueValues Method ####Delete Method ####Item Method ###FreeformBuilder Object ####Application Property ####Creator Property ####Parent Property ####AddNodes Method ####ConvertToShape Method ###FullSeriesCollection Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###Graphic Object ####Application Property ####Brightness Property ####ColorType Property ####Contrast Property ####Creator Property ####CropBottom Property ####CropLeft Property ####CropRight Property ####CropTop Property ####Filename Property ####Height Property ####LockAspectRatio Property ####Parent Property ####Width Property ###Gridlines Object ####Application Property ####Border Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###GroupShapes Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Range Property ####Item Method ###HeaderFooter Object ####Picture Property ####Text Property ###HiLoLines Object ####Application Property ####Border Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###HPageBreak Object ####Application Property ####Creator Property ####Extent Property ####Location Property ####Parent Property ####Type Property ####Delete Method ####DragOff Method ###HPageBreaks Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###Hyperlink Object ####Address Property ####Application Property ####Creator Property ####EmailSubject Property ####Name Property ####Parent Property ####Range Property ####ScreenTip Property ####Shape Property ####SubAddress Property ####TextToDisplay Property ####Type Property ####AddToFavorites Method ####CreateNewDocument Method ####Delete Method ####Follow Method ###Hyperlinks Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Delete Method ###Icon Object ####Application Property ####Creator Property ####Index Property ####Parent Property ###IconCriteria Object ####Count Property ####Item Property ###IconCriterion Object ####Icon Property ####Index Property ####Operator Property ####Type Property ####Value Property ###IconSet Object ####Application Property ####Count Property ####Creator Property ####ID Property ####Item Property ####Parent Property ###IconSetCondition Object ####Application Property ####AppliesTo Property ####Creator Property ####Formula Property ####IconCriteria Property ####IconSet Property ####Parent Property ####PercentileValues Property ####Priority Property ####PTCondition Property ####ReverseOrder Property ####ScopeType Property ####ShowIconOnly Property ####StopIfTrue Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###IconSets Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###Interior Object ####Application Property ####Color Property ####ColorIndex Property ####Creator Property ####Gradient Property ####InvertIfNegative Property ####Parent Property ####Pattern Property ####PatternColor Property ####PatternColorIndex Property ####PatternThemeColor Property ####PatternTintAndShade Property ####ThemeColor Property ####TintAndShade Property ###IRtdServer Object ####ConnectData Method ####DisconnectData Method ####Heartbeat Method ####RefreshData Method ####ServerStart Method ####ServerTerminate Method ###IRTDUpdateEvent Object ####HeartbeatInterval Property ####Disconnect Method ####UpdateNotify Method ###LeaderLines Object ####Application Property ####Border Property ####Creator Property ####Format Property ####Parent Property ####Delete Method ####Select Method ###Legend Object ####Application Property ####Creator Property ####Format Property ####Height Property ####IncludeInLayout Property ####Left Property ####Name Property ####Parent Property ####Position Property ####Shadow Property ####Top Property ####Width Property ####Clear Method ####Delete Method ####LegendEntries Method ####Select Method ###LegendEntries Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###LegendEntry Object ####Application Property ####Creator Property ####Font Property ####Format Property ####Height Property ####Index Property ####Left Property ####LegendKey Property ####Parent Property ####Top Property ####Width Property ####Delete Method ####Select Method ###LegendKey Object ####Application Property ####Creator Property ####Format Property ####Height Property ####InvertIfNegative Property ####Left Property ####MarkerBackgroundColor Property ####MarkerBackgroundColorIndex Property ####MarkerForegroundColor Property ####MarkerForegroundColorIndex Property ####MarkerSize Property ####MarkerStyle Property ####Parent Property ####PictureType Property ####PictureUnit2 Property ####Shadow Property ####Smooth Property ####Top Property ####Width Property ####ClearFormats Method ####Delete Method ###LinearGradient Object ####Application Property ####ColorStops Property ####Creator Property ####Degree Property ####Parent Property ###LineFormat Object ####Application Property ####BackColor Property ####BeginArrowheadLength Property ####BeginArrowheadStyle Property ####BeginArrowheadWidth Property ####Creator Property ####DashStyle Property ####EndArrowheadLength Property ####EndArrowheadStyle Property ####EndArrowheadWidth Property ####ForeColor Property ####InsetPen Property ####Parent Property ####Pattern Property ####Style Property ####Transparency Property ####Visible Property ####Weight Property ###LinkFormat Object ####Application Property ####AutoUpdate Property ####Creator Property ####Locked Property ####Parent Property ####Update Method ###ListColumn Object ####Application Property ####Creator Property ####DataBodyRange Property ####Index Property ####Name Property ####Parent Property ####Range Property ####Total Property ####TotalsCalculation Property ####XPath Property ####Delete Method ###ListColumns Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###ListDataFormat Object ####AllowFillIn Property ####Application Property ####Choices Property ####Creator Property ####DecimalPlaces Property ####DefaultValue Property ####IsPercent Property ####lcid Property ####MaxCharacters Property ####MaxNumber Property ####MinNumber Property ####Parent Property ####ReadOnly Property ####Required Property ####Type Property ###ListObject Object ####Active Property ####AlternativeText Property ####Application Property ####AutoFilter Property ####Comment Property ####Creator Property ####DataBodyRange Property ####DisplayName Property ####DisplayRightToLeft Property ####HeaderRowRange Property ####InsertRowRange Property ####ListColumns Property ####ListRows Property ####Name Property ####Parent Property ####QueryTable Property ####Range Property ####SharePointURL Property ####ShowAutoFilter Property ####ShowAutoFilterDropDown Property ####ShowHeaders Property ####ShowTableStyleColumnStripes Property ####ShowTableStyleFirstColumn Property ####ShowTableStyleLastColumn Property ####ShowTableStyleRowStripes Property ####ShowTotals Property ####Slicers Property ####Sort Property ####SourceType Property ####Summary Property ####TableObject Property ####TableStyle Property ####TotalsRowRange Property ####XmlMap Property ####Delete Method ####ExportToVisio Method ####Publish Method ####Refresh Method ####Resize Method ####Unlink Method ####Unlist Method ###ListObjects Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###ListRow Object ####Application Property ####Creator Property ####Index Property ####Parent Property ####Range Property ####Delete Method ###ListRows Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###Mailer Object ####Application Property ####BCCRecipients Property ####CCRecipients Property ####Creator Property ####Enclosures Property ####Parent Property ####Received Property ####SendDateTime Property ####Sender Property ####Subject Property ####ToRecipients Property ####WhichAddress Property ####Application Property ####Creator Property ####DataModelConnection Property ####ModelFormatBoolean Property ####ModelFormatCurrency Property ####ModelFormatDate Property ####ModelFormatDecimalNumber Property ####ModelFormatGeneral Property ####ModelFormatPercentageNumber Property ####ModelFormatScientificNumber Property ####ModelFormatWholeNumber Property ####ModelMeasures Property ####ModelRelationships Property ####ModelTables Property ####Name Property ####Parent Property ####AddConnection Method ####CreateModelWorkbookConnection Method ####Initialize Method ####Refresh Method ###ModelChanges Object ####Application Property ####ColumnsAdded Property ####ColumnsChanged Property ####ColumnsDeleted Property ####Creator Property ####MeasuresAdded Property ####Parent Property ####RelationshipChange Property ####Source Property ####TableNamesChanged Property ####TablesAdded Property ####TablesDeleted Property ####TablesModified Property ####UnknownChange Property ###ModelColumnChange Object ####Application Property ####ColumnName Property ####Creator Property ####Parent Property ####TableName Property ###ModelColumnChanges Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelColumnName Object ####Application Property ####ColumnName Property ####Creator Property ####Parent Property ####TableName Property ###ModelColumnNames Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelConnection Object ####ADOConnection Property ####Application Property ####CalculatedMembers Property ####CommandText Property ####CommandType Property ####Creator Property ####Parent Property ###ModelFormatBoolean Object ####Application Property ####Creator Property ####Parent Property ###ModelFormatCurrency Object ####Application Property ####Creator Property ####DecimalPlaces Property ####Parent Property ####Symbol Property ###ModelFormatDate Object ####Application Property ####Creator Property ####FormatString Property ####Parent Property ###ModelFormatDecimalNumber Object ####Application Property ####Creator Property ####DecimalPlaces Property ####Parent Property ####UseThousandSeparator Property ###ModelFormatGeneral Object ####Application Property ####Creator Property ####Parent Property ###ModelFormatPercentageNumber Object ####Application Property ####Creator Property ####DecimalPlaces Property ####Parent Property ####UseThousandSeparator Property ###ModelFormatScientificNumber Object ####Application Property ####Creator Property ####DecimalPlaces Property ####Parent Property ###ModelFormatWholeNumber Object ####Application Property ####Creator Property ####Parent Property ####UseThousandSeparator Property ###ModelMeasure Object ####Application Property ####AssociatedTable Property ####Creator Property ####Description Property ####FormatInformation Property ####Formula Property ####Name Property ####Parent Property ####Delete Method ###ModelMeasureName Object ####Application Property ####Creator Property ####MeasureName Property ####Parent Property ####TableName Property ###ModelMeasureNames Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelMeasures Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###ModelRelationship Object ####Active Property ####Application Property ####Creator Property ####ForeignKeyColumn Property ####ForeignKeyTable Property ####Parent Property ####PrimaryKeyColumn Property ####PrimaryKeyTable Property ####Delete Method ###ModelRelationships Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####DetectRelationships Method ####Item Method ###ModelTable Object ####Application Property ####Creator Property ####ModelTableColumns Property ####Name Property ####Parent Property ####RecordCount Property ####SourceName Property ####SourceWorkbookConnection Property ####Refresh Method ###ModelTableColumn Object ####Application Property ####Creator Property ####DataType Property ####Name Property ####Parent Property ###ModelTableColumns Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelTableNameChange Object ####Application Property ####Creator Property ####Parent Property ####TableNameNew Property ####TableNameOld Property ###ModelTableNameChanges Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelTableNames Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModelTables Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ModuleView Object ####Application Property ####Creator Property ####Parent Property ####Sheet Property ###MultiThreadedCalculation Object ####Application Property ####Creator Property ####Enabled Property ####Parent Property ####ThreadCount Property ####ThreadMode Property ###Name Object ####Application Property ####Category Property ####CategoryLocal Property ####Comment Property ####Creator Property ####Index Property ####MacroType Property ####Name Property ####NameLocal Property ####Parent Property ####RefersTo Property ####RefersToLocal Property ####RefersToR1C1 Property ####RefersToR1C1Local Property ####RefersToRange Property ####ShortcutKey Property ####ValidWorkbookParameter Property ####Value Property ####Visible Property ####WorkbookParameter Property ####Delete Method ###Names Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###NegativeBarFormat Object ####Application Property ####BorderColor Property ####BorderColorType Property ####Color Property ####ColorType Property ####Creator Property ####Parent Property ###ODBCConnection Object ####AlwaysUseConnectionFile Property ####Application Property ####BackgroundQuery Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####EnableRefresh Property ####Parent Property ####RefreshDate Property ####Refreshing Property ####RefreshOnFileOpen Property ####RefreshPeriod Property ####RobustConnect Property ####SavePassword Property ####ServerCredentialsMethod Property ####ServerSSOApplicationID Property ####SourceConnectionFile Property ####SourceData Property ####SourceDataFile Property ####CancelRefresh Method ####Refresh Method ####SaveAsODC Method ###ODBCError Object ####Application Property ####Creator Property ####ErrorString Property ####Parent Property ####SqlState Property ###ODBCErrors Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###OLEDBConnection Object ####ADOConnection Property ####AlwaysUseConnectionFile Property ####Application Property ####BackgroundQuery Property ####CalculatedMembers Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####EnableRefresh Property ####IsConnected Property ####LocalConnection Property ####LocaleID Property ####MaintainConnection Property ####MaxDrillthroughRecords Property ####OLAP Property ####Parent Property ####RefreshDate Property ####Refreshing Property ####RefreshOnFileOpen Property ####RefreshPeriod Property ####RetrieveInOfficeUILang Property ####RobustConnect Property ####SavePassword Property ####ServerCredentialsMethod Property ####ServerFillColor Property ####ServerFontStyle Property ####ServerNumberFormat Property ####ServerSSOApplicationID Property ####ServerTextColor Property ####SourceConnectionFile Property ####SourceDataFile Property ####UseLocalConnection Property ####CancelRefresh Method ####MakeConnection Method ####Reconnect Method ####Refresh Method ####SaveAsODC Method ###OLEDBError Object ####Application Property ####Creator Property ####ErrorString Property ####Native Property ####Number Property ####Parent Property ####SqlState Property ####Stage Property ###OLEDBErrors Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###OLEFormat Object ####Application Property ####Creator Property ####Object Property ####Parent Property ####progID Property ####Activate Method ####Verb Method ###OLEObject Object ####Application Property ####AutoLoad Property ####AutoUpdate Property ####Border Property ####BottomRightCell Property ####Creator Property ####Enabled Property ####Height Property ####Index Property ####Interior Property ####Left Property ####LinkedCell Property ####ListFillRange Property ####Locked Property ####Name Property ####Object Property ####OLEType Property ####Parent Property ####Placement Property ####PrintObject Property ####progID Property ####Shadow Property ####ShapeRange Property ####SourceName Property ####Top Property ####TopLeftCell Property ####Visible Property ####Width Property ####ZOrder Property ####Activate Method ####BringToFront Method ####Copy Method ####CopyPicture Method ####Cut Method ####Delete Method ####Duplicate Method ####Select Method ####SendToBack Method ####Update Method ####Verb Method ####GotFocus Event ####LostFocus Event ###OLEObjects Object ####Application Property ####AutoLoad Property ####Border Property ####Count Property ####Creator Property ####Enabled Property ####Height Property ####Interior Property ####Left Property ####Locked Property ####Parent Property ####Placement Property ####PrintObject Property ####Shadow Property ####ShapeRange Property ####SourceName Property ####Top Property ####Visible Property ####Width Property ####ZOrder Property ####Add Method ####BringToFront Method ####Copy Method ####CopyPicture Method ####Cut Method ####Delete Method ####Duplicate Method ####Item Method ####Select Method ####SendToBack Method ###Outline Object ####Application Property ####AutomaticStyles Property ####Creator Property ####Parent Property ####SummaryColumn Property ####SummaryRow Property ####ShowLevels Method ###Page Object ####CenterFooter Property ####CenterHeader Property ####LeftFooter Property ####LeftHeader Property ####RightFooter Property ####RightHeader Property ###Pages Object ####Count Property ####Item Property ###PageSetup Object ####AlignMarginsHeaderFooter Property ####Application Property ####BlackAndWhite Property ####BottomMargin Property ####CenterFooter Property ####CenterFooterPicture Property ####CenterHeader Property ####CenterHeaderPicture Property ####CenterHorizontally Property ####CenterVertically Property ####Creator Property ####DifferentFirstPageHeaderFooter Property ####Draft Property ####EvenPage Property ####FirstPage Property ####FirstPageNumber Property ####FitToPagesTall Property ####FitToPagesWide Property ####FooterMargin Property ####HeaderMargin Property ####LeftFooter Property ####LeftFooterPicture Property ####LeftHeader Property ####LeftHeaderPicture Property ####LeftMargin Property ####OddAndEvenPagesHeaderFooter Property ####Order Property ####Orientation Property ####Pages Property ####PaperSize Property ####Parent Property ####PrintArea Property ####PrintComments Property ####PrintErrors Property ####PrintGridlines Property ####PrintHeadings Property ####PrintNotes Property ####PrintQuality Property ####PrintTitleColumns Property ####PrintTitleRows Property ####RightFooter Property ####RightFooterPicture Property ####RightHeader Property ####RightHeaderPicture Property ####RightMargin Property ####ScaleWithDocHeaderFooter Property ####TopMargin Property ####Zoom Property ###Pane Object ####Application Property ####Creator Property ####Index Property ####Parent Property ####ScrollColumn Property ####ScrollRow Property ####VisibleRange Property ####Activate Method ####LargeScroll Method ####PointsToScreenPixelsX Method ####PointsToScreenPixelsY Method ####ScrollIntoView Method ####SmallScroll Method ###Panes Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###Parameter Object ####Application Property ####Creator Property ####DataType Property ####Name Property ####Parent Property ####PromptString Property ####RefreshOnChange Property ####SourceRange Property ####Type Property ####Value Property ####SetParam Method ###Parameters Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Delete Method ####Item Method ###Phonetic Object ####Alignment Property ####Application Property ####CharacterType Property ####Creator Property ####Font Property ####Parent Property ####Text Property ####Visible Property ###Phonetics Object ####Alignment Property ####Application Property ####CharacterType Property ####Count Property ####Creator Property ####Font Property ####Item Property ####Length Property ####Parent Property ####Start Property ####Text Property ####Visible Property ####Add Method ####Delete Method ###PictureFormat Object ####Application Property ####Brightness Property ####ColorType Property ####Contrast Property ####Creator Property ####Crop Property ####CropBottom Property ####CropLeft Property ####CropRight Property ####CropTop Property ####Parent Property ####TransparencyColor Property ####TransparentBackground Property ####IncrementBrightness Method ####IncrementContrast Method ###PivotAxis Object ####Application Property ####Creator Property ####Parent Property ####PivotLines Property ###PivotCache Object ####ADOConnection Property ####Application Property ####BackgroundQuery Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####EnableRefresh Property ####Index Property ####IsConnected Property ####LocalConnection Property ####MaintainConnection Property ####MemoryUsed Property ####MissingItemsLimit Property ####OLAP Property ####OptimizeCache Property ####Parent Property ####QueryType Property ####RecordCount Property ####Recordset Property ####RefreshDate Property ####RefreshName Property ####RefreshOnFileOpen Property ####RefreshPeriod Property ####RobustConnect Property ####SavePassword Property ####SourceConnectionFile Property ####SourceData Property ####SourceDataFile Property ####SourceType Property ####UpgradeOnRefresh Property ####UseLocalConnection Property ####Version Property ####WorkbookConnection Property ####CreatePivotChart Method ####CreatePivotTable Method ####MakeConnection Method ####Refresh Method ####ResetTimer Method ####SaveAsODC Method ###PivotCaches Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Create Method ####Item Method ###PivotCell Object ####Application Property ####CellChanged Property ####ColumnItems Property ####Creator Property ####CustomSubtotalFunction Property ####DataField Property ####DataSourceValue Property ####MDX Property ####Parent Property ####PivotCellType Property ####PivotColumnLine Property ####PivotField Property ####PivotItem Property ####PivotRowLine Property ####PivotTable Property ####Range Property ####RowItems Property ####ServerActions Property ####AllocateChange Method ####DiscardChange Method ###PivotField Object ####AllItemsVisible Property ####Application Property ####AutoShowCount Property ####AutoShowField Property ####AutoShowRange Property ####AutoShowType Property ####AutoSortCustomSubtotal Property ####AutoSortField Property ####AutoSortOrder Property ####AutoSortPivotLine Property ####BaseField Property ####BaseItem Property ####Calculation Property ####Caption Property ####ChildField Property ####ChildItems Property ####Creator Property ####CubeField Property ####CurrentPage Property ####CurrentPageList Property ####CurrentPageName Property ####DatabaseSort Property ####DataRange Property ####DataType Property ####DisplayAsCaption Property ####DisplayAsTooltip Property ####DisplayInReport Property ####DragToColumn Property ####DragToData Property ####DragToHide Property ####DragToPage Property ####DragToRow Property ####DrilledDown Property ####EnableItemSelection Property ####EnableMultiplePageItems Property ####Formula Property ####Function Property ####GroupLevel Property ####Hidden Property ####HiddenItems Property ####HiddenItemsList Property ####IncludeNewItemsInFilter Property ####IsCalculated Property ####IsMemberProperty Property ####LabelRange Property ####LayoutBlankLine Property ####LayoutCompactRow Property ####LayoutForm Property ####LayoutPageBreak Property ####LayoutSubtotalLocation Property ####MemberPropertyCaption Property ####MemoryUsed Property ####Name Property ####NumberFormat Property ####Orientation Property ####Parent Property ####ParentField Property ####ParentItems Property ####PivotFilters Property ####Position Property ####PropertyOrder Property ####PropertyParentField Property ####RepeatLabels Property ####ServerBased Property ####ShowAllItems Property ####ShowDetail Property ####ShowingInAxis Property ####SourceCaption Property ####SourceName Property ####StandardFormula Property ####SubtotalName Property ####Subtotals Property ####TotalLevels Property ####UseMemberPropertyAsCaption Property ####Value Property ####VisibleItems Property ####VisibleItemsList Property ####AddPageItem Method ####AutoGroup Method ####AutoShow Method ####AutoSort Method ####CalculatedItems Method ####ClearAllFilters Method ####ClearLabelFilters Method ####ClearManualFilter Method ####ClearValueFilters Method ####Delete Method ####DrillTo Method ####PivotItems Method ###PivotFields Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###PivotFilter Object ####Active Property ####Application Property ####Creator Property ####DataCubeField Property ####DataField Property ####Description Property ####FilterType Property ####IsMemberPropertyFilter Property ####MemberPropertyField Property ####Name Property ####Order Property ####Parent Property ####PivotField Property ####Value1 Property ####Value2 Property ####WholeDayFilter Property ####Delete Method ###PivotFilters Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###PivotFormula Object ####Application Property ####Creator Property ####Formula Property ####Index Property ####Parent Property ####StandardFormula Property ####Value Property ####Delete Method ###PivotFormulas Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###PivotItem Object ####Application Property ####Caption Property ####ChildItems Property ####Creator Property ####DataRange Property ####DrilledDown Property ####Formula Property ####IsCalculated Property ####LabelRange Property ####Name Property ####Parent Property ####ParentItem Property ####ParentShowDetail Property ####Position Property ####RecordCount Property ####ShowDetail Property ####SourceName Property ####SourceNameStandard Property ####StandardFormula Property ####Value Property ####Visible Property ####Delete Method ####DrillTo Method ###PivotItemList Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###PivotItems Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###PivotLayout Object ####Application Property ####Creator Property ####Parent Property ####PivotTable Property ###PivotLine Object ####Application Property ####Creator Property ####LineType Property ####Parent Property ####PivotLineCells Property ####PivotLineCellsFull Property ####Position Property ###PivotLineCells Object ####Application Property ####Count Property ####Creator Property ####Full Property ####Item Property ####Parent Property ###PivotLines Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###PivotTable Object ####ActiveFilters Property ####Allocation Property ####AllocationMethod Property ####AllocationValue Property ####AllocationWeightExpression Property ####AllowMultipleFilters Property ####AlternativeText Property ####Application Property ####CacheIndex Property ####CalculatedMembers Property ####CalculatedMembersInFilters Property ####ChangeList Property ####ColumnFields Property ####ColumnGrand Property ####ColumnRange Property ####CompactLayoutColumnHeader Property ####CompactLayoutRowHeader Property ####CompactRowIndent Property ####Creator Property ####CubeFields Property ####DataBodyRange Property ####DataFields Property ####DataLabelRange Property ####DataPivotField Property ####DisplayContextTooltips Property ####DisplayEmptyColumn Property ####DisplayEmptyRow Property ####DisplayErrorString Property ####DisplayFieldCaptions Property ####DisplayImmediateItems Property ####DisplayMemberPropertyTooltips Property ####DisplayNullString Property ####EnableDataValueEditing Property ####EnableDrilldown Property ####EnableFieldDialog Property ####EnableFieldList Property ####EnableWizard Property ####EnableWriteback Property ####ErrorString Property ####FieldListSortAscending Property ####GrandTotalName Property ####HasAutoFormat Property ####Hidden Property ####HiddenFields Property ####InGridDropZones Property ####InnerDetail Property ####LayoutRowDefault Property ####Location Property ####ManualUpdate Property ####MDX Property ####MergeLabels Property ####Name Property ####NullString Property ####PageFieldOrder Property ####PageFields Property ####PageFieldStyle Property ####PageFieldWrapCount Property ####PageRange Property ####PageRangeCells Property ####Parent Property ####PivotChart Property ####PivotColumnAxis Property ####PivotFormulas Property ####PivotRowAxis Property ####PivotSelection Property ####PivotSelectionStandard Property ####PreserveFormatting Property ####PrintDrillIndicators Property ####PrintTitles Property ####RefreshDate Property ####RefreshName Property ####RepeatItemsOnEachPrintedPage Property ####RowFields Property ####RowGrand Property ####RowRange Property ####SaveData Property ####SelectionMode Property ####ShowDrillIndicators Property ####ShowPageMultipleItemLabel Property ####ShowTableStyleColumnHeaders Property ####ShowTableStyleColumnStripes Property ####ShowTableStyleLastColumn Property ####ShowTableStyleRowHeaders Property ####ShowTableStyleRowStripes Property ####ShowValuesRow Property ####Slicers Property ####SmallGrid Property ####SortUsingCustomLists Property ####SourceData Property ####SubtotalHiddenPageItems Property ####Summary Property ####TableRange1 Property ####TableRange2 Property ####TableStyle2 Property ####Tag Property ####TotalsAnnotation Property ####VacatedStyle Property ####Value Property ####Version Property ####ViewCalculatedMembers Property ####VisibleFields Property ####VisualTotals Property ####VisualTotalsForSets Property ####AddDataField Method ####AddFields Method ####AllocateChanges Method ####CalculatedFields Method ####ChangeConnection Method ####ChangePivotCache Method ####ClearAllFilters Method ####ClearTable Method ####CommitChanges Method ####ConvertToFormulas Method ####CreateCubeFile Method ####DiscardChanges Method ####DrillDown Method ####DrillTo Method ####DrillUp Method ####GetData Method ####GetPivotData Method ####ListFormulas Method ####PivotCache Method ####PivotFields Method ####PivotSelect Method ####PivotTableWizard Method ####PivotValueCell Method ####RefreshDataSourceValues Method ####RefreshTable Method ####RepeatAllLabels Method ####RowAxisLayout Method ####ShowPages Method ####SubtotalLocation Method ####Update Method ###PivotTableChangeList Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###PivotTables Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###PivotValueCell Object ####Application Property ####Creator Property ####Parent Property ####PivotCell Property ####ServerActions Property ####Value Property ####ShowDetail Method ###PlotArea Object ####Application Property ####Creator Property ####Format Property ####Height Property ####InsideHeight Property ####InsideLeft Property ####InsideTop Property ####InsideWidth Property ####Left Property ####Name Property ####Parent Property ####Position Property ####Top Property ####Width Property ####ClearFormats Method ####Select Method ###Point Object ####Application Property ####ApplyPictToEnd Property ####ApplyPictToFront Property ####ApplyPictToSides Property ####Creator Property ####DataLabel Property ####Explosion Property ####Format Property ####Has3DEffect Property ####HasDataLabel Property ####Height Property ####InvertIfNegative Property ####IsTotal Property ####Left Property ####MarkerBackgroundColor Property ####MarkerBackgroundColorIndex Property ####MarkerForegroundColor Property ####MarkerForegroundColorIndex Property ####MarkerSize Property ####MarkerStyle Property ####Name Property ####Parent Property ####PictureType Property ####PictureUnit2 Property ####SecondaryPlot Property ####Shadow Property ####Top Property ####Width Property ####ApplyDataLabels Method ####ClearFormats Method ####Copy Method ####Delete Method ####Paste Method ####PieSliceLocation Method ####Select Method ###Points Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###ProtectedViewWindow Object ####Caption Property ####EnableResize Property ####Height Property ####Left Property ####SourceName Property ####SourcePath Property ####Top Property ####Visible Property ####Width Property ####WindowState Property ####Workbook Property ####Activate Method ####Close Method ####Edit Method ###ProtectedViewWindows Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Open Method ###Protection Object ####AllowDeletingColumns Property ####AllowDeletingRows Property ####AllowEditRanges Property ####AllowFiltering Property ####AllowFormattingCells Property ####AllowFormattingColumns Property ####AllowFormattingRows Property ####AllowInsertingColumns Property ####AllowInsertingHyperlinks Property ####AllowInsertingRows Property ####AllowSorting Property ####AllowUsingPivotTables Property ###PublishObject Object ####Application Property ####AutoRepublish Property ####Creator Property ####DivID Property ####Filename Property ####HtmlType Property ####Parent Property ####Sheet Property ####Source Property ####SourceType Property ####Title Property ####Delete Method ####Publish Method ###PublishObjects Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Delete Method ####Publish Method ###Queries Object ####Application Property ####Count Property ####Creator Property ####FastCombine Property ####Parent Property ####Add Method ####Item Method ###QueryTable Object ####AdjustColumnWidth Property ####Application Property ####BackgroundQuery Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####Destination Property ####EditWebPage Property ####EnableEditing Property ####EnableRefresh Property ####FetchedRowOverflow Property ####FieldNames Property ####FillAdjacentFormulas Property ####ListObject Property ####MaintainConnection Property ####Name Property ####Parameters Property ####Parent Property ####PostText Property ####PreserveColumnInfo Property ####PreserveFormatting Property ####QueryType Property ####Recordset Property ####Refreshing Property ####RefreshOnFileOpen Property ####RefreshPeriod Property ####RefreshStyle Property ####ResultRange Property ####RobustConnect Property ####RowNumbers Property ####SaveData Property ####SavePassword Property ####Sort Property ####SourceConnectionFile Property ####SourceDataFile Property ####TextFileColumnDataTypes Property ####TextFileCommaDelimiter Property ####TextFileConsecutiveDelimiter Property ####TextFileDecimalSeparator Property ####TextFileFixedColumnWidths Property ####TextFileOtherDelimiter Property ####TextFileParseType Property ####TextFilePlatform Property ####TextFilePromptOnRefresh Property ####TextFileSemicolonDelimiter Property ####TextFileSpaceDelimiter Property ####TextFileStartRow Property ####TextFileTabDelimiter Property ####TextFileTextQualifier Property ####TextFileThousandsSeparator Property ####TextFileTrailingMinusNumbers Property ####TextFileVisualLayout Property ####WebConsecutiveDelimitersAsOne Property ####WebDisableDateRecognition Property ####WebDisableRedirections Property ####WebFormatting Property ####WebPreFormattedTextToColumns Property ####WebSelectionType Property ####WebSingleBlockTextImport Property ####WebTables Property ####WorkbookConnection Property ####CancelRefresh Method ####Delete Method ####Refresh Method ####ResetTimer Method ####SaveAsODC Method ####AfterRefresh Event ####BeforeRefresh Event ###QueryTables Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###QuickAnalysis Object ####Application Property ####Creator Property ####Parent Property ####Hide Method ####Show Method ###Range Object ####AddIndent Property ####Address Property ####AddressLocal Property ####AllowEdit Property ####Application Property ####Areas Property ####Borders Property ####Cells Property ####Characters Property ####Column Property ####Columns Property ####ColumnWidth Property ####Comment Property ####Count Property ####CountLarge Property ####Creator Property ####CurrentArray Property ####CurrentRegion Property ####Dependents Property ####DirectDependents Property ####DirectPrecedents Property ####DisplayFormat Property ####End Property ####EntireColumn Property ####EntireRow Property ####Errors Property ####Font Property ####FormatConditions Property ####Formula Property ####FormulaArray Property ####FormulaHidden Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####HasArray Property ####HasFormula Property ####Height Property ####Hidden Property ####HorizontalAlignment Property ####Hyperlinks Property ####ID Property ####IndentLevel Property ####Interior Property ####Item Property ####Left Property ####ListHeaderRows Property ####ListObject Property ####LocationInTable Property ####Locked Property ####MDX Property ####MergeArea Property ####MergeCells Property ####Name Property ####Next Property ####NumberFormat Property ####NumberFormatLocal Property ####Offset Property ####Orientation Property ####OutlineLevel Property ####PageBreak Property ####Parent Property ####Phonetic Property ####Phonetics Property ####PivotCell Property ####PivotField Property ####PivotItem Property ####PivotTable Property ####Precedents Property ####PrefixCharacter Property ####Previous Property ####QueryTable Property ####Range Property ####ReadingOrder Property ####Resize Property ####Row Property ####RowHeight Property ####Rows Property ####ServerActions Property ####ShowDetail Property ####ShrinkToFit Property ####SoundNote Property ####SparklineGroups Property ####Style Property ####Summary Property ####Text Property ####Top Property ####UseStandardHeight Property ####UseStandardWidth Property ####Validation Property ####Value Property ####Value2 Property ####VerticalAlignment Property ####Width Property ####Worksheet Property ####WrapText Property ####XPath Property ####Activate Method ####AddComment Method ####AdvancedFilter Method ####AllocateChanges Method ####ApplyNames Method ####ApplyOutlineStyles Method ####AutoComplete Method ####AutoFill Method ####AutoFilter Method ####AutoFit Method ####AutoOutline Method ####BorderAround Method ####Calculate Method ####CalculateRowMajorOrder Method ####CheckSpelling Method ####Clear Method ####ClearComments Method ####ClearContents Method ####ClearFormats Method ####ClearHyperlinks Method ####ClearNotes Method ####ClearOutline Method ####ColumnDifferences Method ####Consolidate Method ####Copy Method ####CopyFromRecordset Method ####CopyPicture Method ####CreateNames Method ####Cut Method ####DataSeries Method ####Delete Method ####DialogBox Method ####Dirty Method ####DiscardChanges Method ####EditionOptions Method ####ExportAsFixedFormat Method ####FillDown Method ####FillLeft Method ####FillRight Method ####FillUp Method ####Find Method ####FindNext Method ####FindPrevious Method ####FlashFill Method ####FunctionWizard Method ####Group Method ####Insert Method ####InsertIndent Method ####Justify Method ####ListNames Method ####Merge Method ####NavigateArrow Method ####NoteText Method ####Parse Method ####PasteSpecial Method ####PrintOut Method ####PrintPreview Method ####RemoveDuplicates Method ####RemoveSubtotal Method ####Replace Method ####RowDifferences Method ####Run Method ####Select Method ####SetPhonetic Method ####Show Method ####ShowDependents Method ####ShowErrors Method ####ShowPrecedents Method ####Sort Method ####SortSpecial Method ####Speak Method ####SpecialCells Method ####SubscribeTo Method ####Subtotal Method ####Table Method ####TextToColumns Method ####Ungroup Method ####UnMerge Method ###Ranges Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###RecentFile Object ####Application Property ####Creator Property ####Index Property ####Name Property ####Parent Property ####Path Property ####Delete Method ####Open Method ###RecentFiles Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Maximum Property ####Parent Property ####Add Method ###RectangularGradient Object ####Application Property ####ColorStops Property ####Creator Property ####Parent Property ####RectangleBottom Property ####RectangleLeft Property ####RectangleRight Property ####RectangleTop Property ###Research Object ####Application Property ####Creator Property ####Parent Property ####IsResearchService Method ####Query Method ####SetLanguagePair Method ###RoutingSlip Object ####Application Property ####Creator Property ####Delivery Property ####Message Property ####Parent Property ####Recipients Property ####ReturnWhenDone Property ####Status Property ####Subject Property ####TrackStatus Property ####Reset Method ###RTD Object ####ThrottleInterval Property ####RefreshData Method ####RestartServers Method ###Scenario Object ####Application Property ####ChangingCells Property ####Comment Property ####Creator Property ####Hidden Property ####Index Property ####Locked Property ####Name Property ####Parent Property ####Values Property ####ChangeScenario Method ####Delete Method ####Show Method ###Scenarios Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####CreateSummary Method ####Item Method ####Merge Method ###Series Object ####Application Property ####ApplyPictToEnd Property ####ApplyPictToFront Property ####ApplyPictToSides Property ####AxisGroup Property ####BarShape Property ####BubbleSizes Property ####ChartType Property ####Creator Property ####ErrorBars Property ####Explosion Property ####Format Property ####Formula Property ####FormulaLocal Property ####FormulaR1C1 Property ####FormulaR1C1Local Property ####Has3DEffect Property ####HasDataLabels Property ####HasErrorBars Property ####HasLeaderLines Property ####InvertColor Property ####InvertColorIndex Property ####InvertIfNegative Property ####IsFiltered Property ####LeaderLines Property ####MarkerBackgroundColor Property ####MarkerBackgroundColorIndex Property ####MarkerForegroundColor Property ####MarkerForegroundColorIndex Property ####MarkerSize Property ####MarkerStyle Property ####Name Property ####Parent Property ####ParentDataLabelOption Property ####PictureType Property ####PictureUnit2 Property ####PlotColorIndex Property ####PlotOrder Property ####QuartileCalculationInclusiveMedian Property ####Shadow Property ####Smooth Property ####Type Property ####Values Property ####XValues Property ####ApplyDataLabels Method ####ClearFormats Method ####Copy Method ####DataLabels Method ####Delete Method ####ErrorBar Method ####Paste Method ####Points Method ####Select Method ####Trendlines Method ###SeriesCollection Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Extend Method ####Item Method ####NewSeries Method ####Paste Method ###SeriesLines Object ####Application Property ####Border Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###ServerViewableItems Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Delete Method ####DeleteAll Method ####Item Method ###ShadowFormat Object ####Application Property ####Blur Property ####Creator Property ####ForeColor Property ####Obscured Property ####OffsetX Property ####OffsetY Property ####Parent Property ####RotateWithShape Property ####Size Property ####Style Property ####Transparency Property ####Type Property ####Visible Property ####IncrementOffsetX Method ####IncrementOffsetY Method ###Shape Object ####Adjustments Property ####AlternativeText Property ####Application Property ####AutoShapeType Property ####BackgroundStyle Property ####BlackWhiteMode Property ####BottomRightCell Property ####Callout Property ####Chart Property ####Child Property ####ConnectionSiteCount Property ####Connector Property ####ConnectorFormat Property ####ControlFormat Property ####Creator Property ####Fill Property ####FormControlType Property ####Glow Property ####GroupItems Property ####HasChart Property ####HasSmartArt Property ####Height Property ####HorizontalFlip Property ####Hyperlink Property ####ID Property ####Left Property ####Line Property ####LinkFormat Property ####LockAspectRatio Property ####Locked Property ####Name Property ####Nodes Property ####OLEFormat Property ####OnAction Property ####Parent Property ####ParentGroup Property ####PictureFormat Property ####Placement Property ####Reflection Property ####Rotation Property ####Shadow Property ####ShapeStyle Property ####SmartArt Property ####SoftEdge Property ####TextEffect Property ####TextFrame Property ####TextFrame2 Property ####ThreeD Property ####Title Property ####Top Property ####TopLeftCell Property ####Type Property ####VerticalFlip Property ####Vertices Property ####Visible Property ####Width Property ####ZOrderPosition Property ####Apply Method ####Copy Method ####CopyPicture Method ####Cut Method ####Delete Method ####Duplicate Method ####Flip Method ####IncrementLeft Method ####IncrementRotation Method ####IncrementTop Method ####PickUp Method ####RerouteConnections Method ####ScaleHeight Method ####ScaleWidth Method ####Select Method ####SetShapesDefaultProperties Method ####Ungroup Method ####ZOrder Method ###ShapeNode Object ####Application Property ####Creator Property ####EditingType Property ####Parent Property ####Points Property ####SegmentType Property ###ShapeNodes Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Delete Method ####Insert Method ####Item Method ####SetEditingType Method ####SetPosition Method ####SetSegmentType Method ###ShapeRange Object ####Adjustments Property ####AlternativeText Property ####Application Property ####AutoShapeType Property ####BackgroundStyle Property ####BlackWhiteMode Property ####Callout Property ####Chart Property ####Child Property ####ConnectionSiteCount Property ####Connector Property ####ConnectorFormat Property ####Count Property ####Creator Property ####Fill Property ####Glow Property ####GroupItems Property ####HasChart Property ####Height Property ####HorizontalFlip Property ####ID Property ####Left Property ####Line Property ####LockAspectRatio Property ####Name Property ####Nodes Property ####Parent Property ####ParentGroup Property ####PictureFormat Property ####Reflection Property ####Rotation Property ####Shadow Property ####ShapeStyle Property ####SoftEdge Property ####TextEffect Property ####TextFrame Property ####TextFrame2 Property ####ThreeD Property ####Title Property ####Top Property ####Type Property ####VerticalFlip Property ####Vertices Property ####Visible Property ####Width Property ####ZOrderPosition Property ####Align Method ####Apply Method ####Delete Method ####Distribute Method ####Duplicate Method ####Flip Method ####Group Method ####IncrementLeft Method ####IncrementRotation Method ####IncrementTop Method ####Item Method ####PickUp Method ####Regroup Method ####RerouteConnections Method ####ScaleHeight Method ####ScaleWidth Method ####Select Method ####SetShapesDefaultProperties Method ####Ungroup Method ####ZOrder Method ###Shapes Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Range Property ####AddCallout Method ####AddChart2 Method ####AddConnector Method ####AddCurve Method ####AddFormControl Method ####AddLabel Method ####AddLine Method ####AddOLEObject Method ####AddPicture Method ####AddPicture2 Method ####AddPolyline Method ####AddShape Method ####AddSmartArt Method ####AddTextbox Method ####AddTextEffect Method ####BuildFreeform Method ####Item Method ####SelectAll Method ###Sheets Object ####Application Property ####Count Property ####Creator Property ####HPageBreaks Property ####Item Property ####Parent Property ####Visible Property ####VPageBreaks Property ####Add Method ####Add2 Method ####Copy Method ####Delete Method ####FillAcrossSheets Method ####Move Method ####PrintOut Method ####PrintPreview Method ####Select Method ###SheetViews Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###Slicer Object ####ActiveItem Property ####Application Property ####Caption Property ####ColumnWidth Property ####Creator Property ####DisableMoveResizeUI Property ####DisplayHeader Property ####Height Property ####Left Property ####Locked Property ####Name Property ####NumberOfColumns Property ####Parent Property ####RowHeight Property ####Shape Property ####SlicerCache Property ####SlicerCacheLevel Property ####SlicerCacheType Property ####Style Property ####TimelineViewState Property ####Top Property ####Width Property ####Copy Method ####Cut Method ####Delete Method ###SlicerCache Object ####Application Property ####Creator Property ####CrossFilterType Property ####FilterCleared Property ####Index Property ####List Property ####ListObject Property ####Name Property ####OLAP Property ####Parent Property ####PivotTables Property ####RequireManualUpdate Property ####ShowAllItems Property ####SlicerCacheLevels Property ####SlicerCacheType Property ####SlicerItems Property ####Slicers Property ####SortItems Property ####SortUsingCustomLists Property ####SourceName Property ####SourceType Property ####TimelineState Property ####VisibleSlicerItems Property ####VisibleSlicerItemsList Property ####WorkbookConnection Property ####ClearAllFilters Method ####ClearDateFilter Method ####ClearManualFilter Method ####Delete Method ###SlicerCacheLevel Object ####Application Property ####Count Property ####Creator Property ####CrossFilterType Property ####Name Property ####Ordinal Property ####Parent Property ####SlicerItems Property ####SortItems Property ####VisibleSlicerItemsList Property ###SlicerCacheLevels Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###SlicerCaches Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###SlicerItem Object ####Application Property ####Caption Property ####Creator Property ####HasData Property ####Name Property ####Parent Property ####Selected Property ####SourceName Property ####SourceNameStandard Property ####Value Property ###SlicerItems Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###SlicerPivotTables Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####AddPivotTable Method ####RemovePivotTable Method ###Slicers Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###Sort Object ####Application Property ####Creator Property ####Header Property ####MatchCase Property ####Orientation Property ####Parent Property ####Rng Property ####SortFields Property ####SortMethod Property ####Apply Method ####SetRange Method ###SortField Object ####Application Property ####Creator Property ####CustomOrder Property ####DataOption Property ####Key Property ####Order Property ####Parent Property ####Priority Property ####SortOn Property ####SortOnValue Property ####Delete Method ####ModifyKey Method ####SetIcon Method ###SortFields Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Clear Method ####Application Property ####Creator Property ####Parent Property ####Delete Method ####Import Method ####Play Method ####Record Method ###SparkAxes Object ####Application Property ####Creator Property ####Horizontal Property ####Parent Property ####Vertical Property ###SparkColor Object ####Application Property ####Color Property ####Creator Property ####Parent Property ####Visible Property ###SparkHorizontalAxis Object ####Application Property ####Axis Property ####Creator Property ####IsDateAxis Property ####Parent Property ####RightToLeftPlotOrder Property ###Sparkline Object ####Application Property ####Creator Property ####Location Property ####Parent Property ####SourceData Property ####ModifyLocation Method ####ModifySourceData Method ###SparklineGroup Object ####Application Property ####Axes Property ####Count Property ####Creator Property ####DateRange Property ####DisplayBlanksAs Property ####DisplayHidden Property ####Item Property ####LineWeight Property ####Location Property ####Parent Property ####PlotBy Property ####Points Property ####SeriesColor Property ####SourceData Property ####Type Property ####Delete Method ####Modify Method ####ModifyDateRange Method ####ModifyLocation Method ####ModifySourceData Method ###SparklineGroups Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Clear Method ####ClearGroups Method ####Group Method ####Ungroup Method ###SparkPoints Object ####Application Property ####Creator Property ####Firstpoint Property ####Highpoint Property ####Lastpoint Property ####Lowpoint Property ####Markers Property ####Negative Property ####Parent Property ###SparkVerticalAxis Object ####Application Property ####Creator Property ####CustomMaxScaleValue Property ####CustomMinScaleValue Property ####MaxScaleType Property ####MinScaleType Property ####Parent Property ###Speech Object ####Direction Property ####SpeakCellOnEnter Property ####Speak Method ###SpellingOptions Object ####ArabicModes Property ####ArabicStrictAlefHamza Property ####ArabicStrictFinalYaa Property ####ArabicStrictTaaMarboota Property ####BrazilReform Property ####DictLang Property ####GermanPostReform Property ####HebrewModes Property ####IgnoreCaps Property ####IgnoreFileNames Property ####IgnoreMixedDigits Property ####KoreanCombineAux Property ####KoreanProcessCompound Property ####KoreanUseAutoChangeList Property ####PortugalReform Property ####RussianStrictE Property ####SpanishModes Property ####SuggestMainOnly Property ####UserDict Property ###Style Object ####AddIndent Property ####Application Property ####Borders Property ####BuiltIn Property ####Creator Property ####Font Property ####FormulaHidden Property ####HorizontalAlignment Property ####IncludeAlignment Property ####IncludeBorder Property ####IncludeFont Property ####IncludeNumber Property ####IncludePatterns Property ####IncludeProtection Property ####IndentLevel Property ####Interior Property ####Locked Property ####MergeCells Property ####Name Property ####NameLocal Property ####NumberFormat Property ####NumberFormatLocal Property ####Orientation Property ####Parent Property ####ReadingOrder Property ####ShrinkToFit Property ####Value Property ####VerticalAlignment Property ####WrapText Property ####Delete Method ###Styles Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Merge Method ###Tab Object ####Application Property ####Color Property ####ColorIndex Property ####Creator Property ####Parent Property ####ThemeColor Property ####TintAndShade Property ###TableObject Object ####AdjustColumnWidth Property ####Application Property ####Creator Property ####Destination Property ####EnableEditing Property ####EnableRefresh Property ####FetchedRowOverflow Property ####ListObject Property ####Parent Property ####PreserveColumnInfo Property ####PreserveFormatting Property ####RefreshStyle Property ####ResultRange Property ####RowNumbers Property ####WorkbookConnection Property ####Delete Method ####Refresh Method ###TableStyle Object ####Application Property ####BuiltIn Property ####Creator Property ####Name Property ####NameLocal Property ####Parent Property ####ShowAsAvailablePivotTableStyle Property ####ShowAsAvailableSlicerStyle Property ####ShowAsAvailableTableStyle Property ####ShowAsAvailableTimelineStyle Property ####TableStyleElements Property ####Delete Method ####Duplicate Method ###TableStyleElement Object ####Application Property ####Borders Property ####Creator Property ####Font Property ####HasFormat Property ####Interior Property ####Parent Property ####StripeSize Property ####Clear Method ###TableStyleElements Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Item Method ###TableStyles Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###TextConnection Object ####Application Property ####Connection Property ####Creator Property ####Parent Property ####TextFileColumnDataTypes Property ####TextFileCommaDelimiter Property ####TextFileConsecutiveDelimiter Property ####TextFileDecimalSeparator Property ####TextFileFixedColumnWidths Property ####TextFileHeaderRow Property ####TextFileOtherDelimiter Property ####TextFileParseType Property ####TextFilePlatform Property ####TextFilePromptOnRefresh Property ####TextFileSemicolonDelimiter Property ####TextFileSpaceDelimiter Property ####TextFileStartRow Property ####TextFileTabDelimiter Property ####TextFileTextQualifier Property ####TextFileThousandsSeparator Property ####TextFileTrailingMinusNumbers Property ####TextFileVisualLayout Property ###TextEffectFormat Object ####Alignment Property ####Application Property ####Creator Property ####FontBold Property ####FontItalic Property ####FontName Property ####FontSize Property ####KernedPairs Property ####NormalizedHeight Property ####Parent Property ####PresetShape Property ####PresetTextEffect Property ####RotatedChars Property ####Text Property ####Tracking Property ####ToggleVerticalText Method ###TextFrame Object ####Application Property ####AutoMargins Property ####AutoSize Property ####Creator Property ####HorizontalAlignment Property ####HorizontalOverflow Property ####MarginBottom Property ####MarginLeft Property ####MarginRight Property ####MarginTop Property ####Orientation Property ####Parent Property ####ReadingOrder Property ####VerticalAlignment Property ####VerticalOverflow Property ####Characters Method ###TextFrame2 Object ####Application Property ####AutoSize Property ####Column Property ####Creator Property ####HasText Property ####HorizontalAnchor Property ####MarginBottom Property ####MarginLeft Property ####MarginRight Property ####MarginTop Property ####NoTextRotation Property ####Orientation Property ####Parent Property ####PathFormat Property ####Ruler Property ####TextRange Property ####ThreeD Property ####VerticalAnchor Property ####WarpFormat Property ####WordArtformat Property ####WordWrap Property ####DeleteText Method ###ThreeDFormat Object ####Application Property ####BevelBottomDepth Property ####BevelBottomInset Property ####BevelBottomType Property ####BevelTopDepth Property ####BevelTopInset Property ####BevelTopType Property ####ContourColor Property ####ContourWidth Property ####Creator Property ####Depth Property ####ExtrusionColor Property ####ExtrusionColorType Property ####FieldOfView Property ####LightAngle Property ####Parent Property ####Perspective Property ####PresetCamera Property ####PresetExtrusionDirection Property ####PresetLighting Property ####PresetLightingDirection Property ####PresetLightingSoftness Property ####PresetMaterial Property ####PresetThreeDFormat Property ####ProjectText Property ####RotationX Property ####RotationY Property ####RotationZ Property ####Visible Property ####Z Property ####IncrementRotationHorizontal Method ####IncrementRotationVertical Method ####IncrementRotationX Method ####IncrementRotationY Method ####IncrementRotationZ Method ####ResetRotation Method ####SetExtrusionDirection Method ####SetPresetCamera Method ####SetThreeDFormat Method ###TickLabels Object ####Alignment Property ####Application Property ####Creator Property ####Depth Property ####Font Property ####Format Property ####MultiLevel Property ####Name Property ####NumberFormat Property ####NumberFormatLinked Property ####NumberFormatLocal Property ####Offset Property ####Orientation Property ####Parent Property ####ReadingOrder Property ####Delete Method ####Select Method ###TimelineState Object ####Application Property ####Creator Property ####EndDate Property ####FilterType Property ####FilterValue1 Property ####FilterValue2 Property ####Parent Property ####SingleRangeFilterState Property ####StartDate Property ####SetFilterDateRange Method ###TimelineViewState Object ####Application Property ####Creator Property ####Level Property ####Parent Property ####ShowHeader Property ####ShowHorizontalScrollbar Property ####ShowSelectionLabel Property ####ShowTimeLevel Property ###Top10 Object ####Application Property ####AppliesTo Property ####Borders Property ####CalcFor Property ####Creator Property ####Font Property ####Interior Property ####NumberFormat Property ####Parent Property ####Percent Property ####Priority Property ####PTCondition Property ####Rank Property ####ScopeType Property ####StopIfTrue Property ####TopBottom Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###TreeviewControl Object ####Application Property ####Creator Property ####Drilled Property ####Hidden Property ####Parent Property ###Trendline Object ####Application Property ####Backward2 Property ####Border Property ####Creator Property ####DataLabel Property ####DisplayEquation Property ####DisplayRSquared Property ####Format Property ####Forward2 Property ####Index Property ####Intercept Property ####InterceptIsAuto Property ####Name Property ####NameIsAuto Property ####Order Property ####Parent Property ####Period Property ####Type Property ####ClearFormats Method ####Delete Method ####Select Method ###Trendlines Object ####Application Property ####Count Property ####Creator Property ####Parent Property ####Add Method ####Item Method ###UniqueValues Object ####Application Property ####AppliesTo Property ####Borders Property ####Creator Property ####DupeUnique Property ####Font Property ####Interior Property ####NumberFormat Property ####Parent Property ####Priority Property ####PTCondition Property ####ScopeType Property ####StopIfTrue Property ####Type Property ####Delete Method ####ModifyAppliesToRange Method ####SetFirstPriority Method ####SetLastPriority Method ###UpBars Object ####Application Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####Delete Method ####Select Method ###UsedObjects Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###UserAccess Object ####AllowEdit Property ####Name Property ####Delete Method ###UserAccessList Object ####Count Property ####Item Property ####Add Method ####DeleteAll Method ###Validation Object ####AlertStyle Property ####Application Property ####Creator Property ####ErrorMessage Property ####ErrorTitle Property ####Formula1 Property ####Formula2 Property ####IgnoreBlank Property ####IMEMode Property ####InCellDropdown Property ####InputMessage Property ####InputTitle Property ####Operator Property ####Parent Property ####ShowError Property ####ShowInput Property ####Type Property ####Value Property ####Add Method ####Delete Method ####Modify Method ###ValueChange Object ####AllocationMethod Property ####AllocationValue Property ####AllocationWeightExpression Property ####Application Property ####Creator Property ####Order Property ####Parent Property ####PivotCell Property ####Tuple Property ####Value Property ####VisibleInPivotTable Property ####Delete Method ###VPageBreak Object ####Application Property ####Creator Property ####Extent Property ####Location Property ####Parent Property ####Type Property ####Delete Method ####DragOff Method ###VPageBreaks Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###Walls Object ####Application Property ####Creator Property ####Format Property ####Name Property ####Parent Property ####PictureType Property ####PictureUnit Property ####Thickness Property ####ClearFormats Method ####Paste Method ####Select Method ###Watch Object ####Application Property ####Creator Property ####Parent Property ####Source Property ####Delete Method ###Watches Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####Delete Method ###WebOptions Object ####AllowPNG Property ####Application Property ####Creator Property ####DownloadComponents Property ####Encoding Property ####FolderSuffix Property ####LocationOfComponents Property ####OrganizeInFolder Property ####Parent Property ####PixelsPerInch Property ####RelyOnCSS Property ####RelyOnVML Property ####ScreenSize Property ####TargetBrowser Property ####UseLongFileNames Property ####UseDefaultFolderSuffix Method ###Window Object ####ActiveCell Property ####ActiveChart Property ####ActivePane Property ####ActiveSheet Property ####ActiveSheetView Property ####Application Property ####AutoFilterDateGrouping Property ####Caption Property ####Creator Property ####DisplayFormulas Property ####DisplayGridlines Property ####DisplayHeadings Property ####DisplayHorizontalScrollBar Property ####DisplayOutline Property ####DisplayRightToLeft Property ####DisplayRuler Property ####DisplayVerticalScrollBar Property ####DisplayWhitespace Property ####DisplayWorkbookTabs Property ####DisplayZeros Property ####EnableResize Property ####FreezePanes Property ####GridlineColor Property ####GridlineColorIndex Property ####Height Property ####Hwnd Property ####Index Property ####Left Property ####OnWindow Property ####Panes Property ####Parent Property ####RangeSelection Property ####ScrollColumn Property ####ScrollRow Property ####SelectedSheets Property ####Selection Property ####SheetViews Property ####Split Property ####SplitColumn Property ####SplitHorizontal Property ####SplitRow Property ####SplitVertical Property ####TabRatio Property ####Top Property ####Type Property ####UsableHeight Property ####UsableWidth Property ####View Property ####Visible Property ####VisibleRange Property ####Width Property ####WindowNumber Property ####WindowState Property ####Zoom Property ####Activate Method ####ActivateNext Method ####ActivatePrevious Method ####Close Method ####LargeScroll Method ####NewWindow Method ####PointsToScreenPixelsX Method ####PointsToScreenPixelsY Method ####PrintOut Method ####PrintPreview Method ####RangeFromPoint Method ####ScrollIntoView Method ####ScrollWorkbookTabs Method ####SmallScroll Method ###Windows Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####SyncScrollingSideBySide Property ####Arrange Method ####BreakSideBySide Method ####CompareSideBySideWith Method ####ResetPositionsSideBySide Method ###Workbook Object ####AccuracyVersion Property ####ActiveChart Property ####ActiveSheet Property ####ActiveSlicer Property ####Application Property ####AutoUpdateFrequency Property ####AutoUpdateSaveChanges Property ####BuiltinDocumentProperties Property ####CalculationVersion Property ####CaseSensitive Property ####ChangeHistoryDuration Property ####ChartDataPointTrack Property ####Charts Property ####CheckCompatibility Property ####CodeName Property ####Colors Property ####CommandBars Property ####ConflictResolution Property ####Connections Property ####ConnectionsDisabled Property ####Container Property ####ContentTypeProperties Property ####CreateBackup Property ####Creator Property ####CustomDocumentProperties Property ####CustomViews Property ####CustomXMLParts Property ####Date1904 Property ####DefaultPivotTableStyle Property ####DefaultSlicerStyle Property ####DefaultTableStyle Property ####DefaultTimelineStyle Property ####DisplayDrawingObjects Property ####DisplayInkComments Property ####DocumentInspectors Property ####DocumentLibraryVersions Property ####DoNotPromptForConvert Property ####EnableAutoRecover Property ####EncryptionProvider Property ####EnvelopeVisible Property ####Excel4IntlMacroSheets Property ####Excel4MacroSheets Property ####Excel8CompatibilityMode Property ####FileFormat Property ####Final Property ####ForceFullCalculation Property ####FullName Property ####FullNameURLEncoded Property ####HasPassword Property ####HasVBProject Property ####HighlightChangesOnScreen Property ####IconSets Property ####InactiveListBorderVisible Property ####IsAddin Property ####IsInplace Property ####KeepChangeHistory Property ####ListChangesOnNewSheet Property ####Mailer Property ####Model Property ####MultiUserEditing Property ####Name Property ####Names Property ####Parent Property ####Password Property ####PasswordEncryptionAlgorithm Property ####PasswordEncryptionFileProperties Property ####PasswordEncryptionKeyLength Property ####PasswordEncryptionProvider Property ####Path Property ####Permission Property ####PersonalViewListSettings Property ####PersonalViewPrintSettings Property ####PivotTables Property ####PrecisionAsDisplayed Property ####ProtectStructure Property ####ProtectWindows Property ####PublishObjects Property ####Queries Property ####ReadOnly Property ####ReadOnlyRecommended Property ####RemovePersonalInformation Property ####Research Property ####RevisionNumber Property ####Saved Property ####SaveLinkValues Property ####ServerPolicy Property ####ServerViewableItems Property ####SharedWorkspace Property ####Sheets Property ####ShowConflictHistory Property ####ShowPivotChartActiveFields Property ####ShowPivotTableFieldList Property ####Signatures Property ####SlicerCaches Property ####SmartDocument Property ####Styles Property ####Sync Property ####TableStyles Property ####TemplateRemoveExtData Property ####Theme Property ####UpdateLinks Property ####UpdateRemoteReferences Property ####UserStatus Property ####UseWholeCellCriteria Property ####UseWildcards Property ####VBASigned Property ####VBProject Property ####WebOptions Property ####Windows Property ####Worksheets Property ####WritePassword Property ####WriteReserved Property ####WriteReservedBy Property ####XmlMaps Property ####XmlNamespaces Property ####AcceptAllChanges Method ####Activate Method ####AddToFavorites Method ####ApplyTheme Method ####BreakLink Method ####CanCheckIn Method ####ChangeFileAccess Method ####ChangeLink Method ####CheckIn Method ####CheckInWithVersion Method ####Close Method ####CreateForecastSheet Method ####DeleteNumberFormat Method ####EnableConnections Method ####EndReview Method ####ExclusiveAccess Method ####ExportAsFixedFormat Method ####FollowHyperlink Method ####ForwardMailer Method ####GetWorkflowTasks Method ####GetWorkflowTemplates Method ####HighlightChangesOptions Method ####LinkInfo Method ####LinkSources Method ####LockServerFile Method ####MergeWorkbook Method ####NewWindow Method ####OpenLinks Method ####PivotCaches Method ####Post Method ####PrintOut Method ####PrintPreview Method ####Protect Method ####ProtectSharing Method ####PurgeChangeHistoryNow Method ####RefreshAll Method ####RejectAllChanges Method ####ReloadAs Method ####RemoveDocumentInformation Method ####RemoveUser Method ####Reply Method ####ReplyAll Method ####ReplyWithChanges Method ####ResetColors Method ####RunAutoMacros Method ####Save Method ####SaveAs Method ####SaveAsXMLData Method ####SaveCopyAs Method ####SendFaxOverInternet Method ####SendForReview Method ####SendMail Method ####SendMailer Method ####SetLinkOnData Method ####SetPasswordEncryptionOptions Method ####ToggleFormsDesign Method ####Unprotect Method ####UnprotectSharing Method ####UpdateFromFile Method ####UpdateLink Method ####WebPagePreview Method ####XmlImport Method ####XmlImportXml Method ####Activate Event ####AddinInstall Event ####AddinUninstall Event ####AfterSave Event ####AfterXmlExport Event ####AfterXmlImport Event ####BeforeClose Event ####BeforePrint Event ####BeforeSave Event ####BeforeXmlExport Event ####BeforeXmlImport Event ####Deactivate Event ####ModelChange Event ####NewChart Event ####NewSheet Event ####Open Event ####PivotTableCloseConnection Event ####PivotTableOpenConnection Event ####RowsetComplete Event ####SheetActivate Event ####SheetBeforeDelete Event ####SheetBeforeDoubleClick Event ####SheetBeforeRightClick Event ####SheetCalculate Event ####SheetChange Event ####SheetDeactivate Event ####SheetFollowHyperlink Event ####SheetLensGalleryRenderComplete Event ####SheetPivotTableAfterValueChange Event ####SheetPivotTableBeforeAllocateChanges Event ####SheetPivotTableBeforeCommitChanges Event ####SheetPivotTableBeforeDiscardChanges Event ####SheetPivotTableChangeSync Event ####SheetPivotTableUpdate Event ####SheetSelectionChange Event ####SheetTableUpdate Event ####Sync Event ####WindowActivate Event ####WindowDeactivate Event ####WindowResize Event ###WorkbookConnection Object ####Application Property ####Creator Property ####DataFeedConnection Property ####Description Property ####InModel Property ####ModelConnection Property ####ModelTables Property ####Name Property ####ODBCConnection Property ####OLEDBConnection Property ####Parent Property ####Ranges Property ####RefreshWithRefreshAll Property ####TextConnection Property ####Type Property ####WorksheetDataConnection Property ####Delete Method ####Refresh Method ###WorkbookQuery Object ####Application Property ####Creator Property ####Description Property ####Formula Property ####Name Property ####Parent Property ####Delete Method ###Workbooks Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ####CanCheckOut Method ####CheckOut Method ####Close Method ####Open Method ####OpenDatabase Method ####OpenText Method ####OpenXML Method ###Worksheet Object ####Application Property ####AutoFilter Property ####AutoFilterMode Property ####Cells Property ####CircularReference Property ####CodeName Property ####Columns Property ####Comments Property ####ConsolidationFunction Property ####ConsolidationOptions Property ####ConsolidationSources Property ####Creator Property ####CustomProperties Property ####DisplayPageBreaks Property ####DisplayRightToLeft Property ####EnableAutoFilter Property ####EnableCalculation Property ####EnableFormatConditionsCalculation Property ####EnableOutlining Property ####EnablePivotTable Property ####EnableSelection Property ####FilterMode Property ####HPageBreaks Property ####Hyperlinks Property ####Index Property ####ListObjects Property ####MailEnvelope Property ####Name Property ####Names Property ####Next Property ####Outline Property ####PageSetup Property ####Parent Property ####Previous Property ####PrintedCommentPages Property ####ProtectContents Property ####ProtectDrawingObjects Property ####Protection Property ####ProtectionMode Property ####ProtectScenarios Property ####QueryTables Property ####Range Property ####Rows Property ####ScrollArea Property ####Shapes Property ####Sort Property ####StandardHeight Property ####StandardWidth Property ####Tab Property ####TransitionExpEval Property ####TransitionFormEntry Property ####Type Property ####UsedRange Property ####Visible Property ####VPageBreaks Property ####Activate Method ####Calculate Method ####ChartObjects Method ####CheckSpelling Method ####CircleInvalid Method ####ClearArrows Method ####ClearCircles Method ####Copy Method ####Delete Method ####Evaluate Method ####ExportAsFixedFormat Method ####Move Method ####OLEObjects Method ####Paste Method ####PasteSpecial Method ####PivotTables Method ####PivotTableWizard Method ####PrintOut Method ####PrintPreview Method ####Protect Method ####ResetAllPageBreaks Method ####SaveAs Method ####Scenarios Method ####Select Method ####SetBackgroundPicture Method ####ShowAllData Method ####ShowDataForm Method ####Unprotect Method ####XmlDataQuery Method ####XmlMapQuery Method ####Activate Event ####BeforeDelete Event ####BeforeDoubleClick Event ####BeforeRightClick Event ####Calculate Event ####Change Event ####Deactivate Event ####FollowHyperlink Event ####LensGalleryRenderComplete Event ####PivotTableAfterValueChange Event ####PivotTableBeforeAllocateChanges Event ####PivotTableBeforeCommitChanges Event ####PivotTableBeforeDiscardChanges Event ####PivotTableChangeSync Event ####PivotTableUpdate Event ####SelectionChange Event ####TableUpdate Event ###WorksheetDataConnection Object ####Application Property ####CommandText Property ####CommandType Property ####Connection Property ####Creator Property ####Parent Property ###WorksheetFunction Object ####Application Property ####Creator Property ####Parent Property ####AccrInt Method ####AccrIntM Method ####Acos Method ####Acosh Method ####Acot Method ####Acoth Method ####Aggregate Method ####AmorDegrc Method ####AmorLinc Method ####And Method ####Arabic Method ####Asc Method ####Asin Method ####Asinh Method ####Atan2 Method ####Atanh Method ####AveDev Method ####Average Method ####AverageIf Method ####AverageIfs Method ####BahtText Method ####Base Method ####BesselI Method ####BesselJ Method ####BesselK Method ####BesselY Method ####Beta_Dist Method ####Beta_Inv Method ####BetaDist Method ####BetaInv Method ####Bin2Dec Method ####Bin2Hex Method ####Bin2Oct Method ####Binom_Dist Method ####Binom_Dist_Range Method ####Binom_Inv Method ####BinomDist Method ####Bitand Method ####Bitlshift Method ####Bitor Method ####Bitrshift Method ####Bitxor Method ####Ceiling Method ####Ceiling_Math Method ####Ceiling_Precise Method ####ChiDist Method ####ChiInv Method ####ChiSq_Dist Method ####ChiSq_Dist_RT Method ####ChiSq_Inv Method ####ChiSq_Inv_RT Method ####ChiSq_Test Method ####ChiTest Method ####Choose Method ####Clean Method ####Combin Method ####Combina Method ####Complex Method ####Confidence Method ####Confidence_Norm Method ####Confidence_T Method ####Convert Method ####Correl Method ####Cosh Method ####Cot Method ####Coth Method ####Count Method ####CountA Method ####CountBlank Method ####CountIf Method ####CountIfs Method ####CoupDayBs Method ####CoupDays Method ####CoupDaysNc Method ####CoupNcd Method ####CoupNum Method ####CoupPcd Method ####Covar Method ####Covariance_P Method ####Covariance_S Method ####CritBinom Method ####Csc Method ####Csch Method ####CumIPmt Method ####CumPrinc Method ####DAverage Method ####Days Method ####Days360 Method ####Db Method ####Dbcs Method ####DCount Method ####DCountA Method ####Ddb Method ####Dec2Bin Method ####Dec2Hex Method ####Dec2Oct Method ####Decimal Method ####Degrees Method ####Delta Method ####DevSq Method ####DGet Method ####Disc Method ####DMax Method ####DMin Method ####Dollar Method ####DollarDe Method ####DollarFr Method ####DProduct Method ####DStDev Method ####DStDevP Method ####DSum Method ####Duration Method ####DVar Method ####DVarP Method ####EDate Method ####Effect Method ####EncodeUrl Method ####EoMonth Method ####Erf Method ####Erf_Precise Method ####ErfC Method ####ErfC_Precise Method ####Even Method ####Expon_Dist Method ####ExponDist Method ####F_Dist Method ####F_Dist_RT Method ####F_Inv Method ####F_Inv_RT Method ####F_Test Method ####Fact Method ####FactDouble Method ####FDist Method ####FilterXML Method ####Find Method ####FindB Method ####FInv Method ####Fisher Method ####FisherInv Method ####Fixed Method ####Floor Method ####Floor_Math Method ####Floor_Precise Method ####Forecast_ETS Method ####Forecast Method ####Forecast_ETS_ConfInt Method ####Forecast_ETS_Seasonality Method ####Forecast_ETS_STAT Method ####Forecast_Linear Method ####Frequency Method ####FTest Method ####Fv Method ####FVSchedule Method ####Gamma Method ####Gamma_Dist Method ####Gamma_Inv Method ####GammaDist Method ####GammaInv Method ####GammaLn Method ####GammaLn_Precise Method ####Gauss Method ####Gcd Method ####GeoMean Method ####GeStep Method ####Growth Method ####HarMean Method ####Hex2Bin Method ####Hex2Dec Method ####Hex2Oct Method ####HLookup Method ####HypGeom_Dist Method ####HypGeomDist Method ####IfError Method ####IfNa Method ####ImAbs Method ####Imaginary Method ####ImArgument Method ####ImConjugate Method ####ImCos Method ####ImCosh Method ####ImCot Method ####ImCsc Method ####ImCsch Method ####ImDiv Method ####ImExp Method ####ImLn Method ####ImLog10 Method ####ImLog2 Method ####ImPower Method ####ImProduct Method ####ImReal Method ####ImSec Method ####ImSech Method ####ImSin Method ####ImSinh Method ####ImSqrt Method ####ImSub Method ####ImSum Method ####ImTan Method ####Index Method ####Intercept Method ####IntRate Method ####Ipmt Method ####Irr Method ####IsErr Method ####IsError Method ####IsEven Method ####IsFormula Method ####IsLogical Method ####IsNA Method ####IsNonText Method ####IsNumber Method ####ISO_Ceiling Method ####IsOdd Method ####IsoWeekNum Method ####Ispmt Method ####IsText Method ####Kurt Method ####Large Method ####Lcm Method ####LinEst Method ####Ln Method ####Log Method ####Log10 Method ####LogEst Method ####LogInv Method ####LogNorm_Dist Method ####LogNorm_Inv Method ####LogNormDist Method ####Lookup Method ####Match Method ####Max Method ####MDeterm Method ####MDuration Method ####Median Method ####Min Method ####MInverse Method ####MIrr Method ####MMult Method ####Mode Method ####Mode_Mult Method ####Mode_Sngl Method ####MRound Method ####MultiNomial Method ####Munit Method ####NegBinom_Dist Method ####NegBinomDist Method ####NetworkDays Method ####NetworkDays_Intl Method ####Nominal Method ####Norm_Dist Method ####Norm_Inv Method ####Norm_S_Dist Method ####Norm_S_Inv Method ####NormDist Method ####NormInv Method ####NormSDist Method ####NormSInv Method ####NPer Method ####Npv Method ####NumberValue Method ####Oct2Bin Method ####Oct2Dec Method ####Oct2Hex Method ####Odd Method ####OddFPrice Method ####OddFYield Method ####OddLPrice Method ####OddLYield Method ####Or Method ####PDuration Method ####Pearson Method ####Percentile Method ####Percentile_Exc Method ####Percentile_Inc Method ####PercentRank Method ####PercentRank_Exc Method ####PercentRank_Inc Method ####Permut Method ####Permutationa Method ####Phi Method ####Phonetic Method ####Pi Method ####Pmt Method ####Poisson Method ####Poisson_Dist Method ####Power Method ####Ppmt Method ####Price Method ####PriceDisc Method ####PriceMat Method ####Prob Method ####Product Method ####Proper Method ####Pv Method ####Quartile Method ####Quartile_Exc Method ####Quartile_Inc Method ####Quotient Method ####Radians Method ####RandBetween Method ####Rank Method ####Rank_Avg Method ####Rank_Eq Method ####Rate Method ####Received Method ####Replace Method ####ReplaceB Method ####Rept Method ####Roman Method ####Round Method ####RoundDown Method ####RoundUp Method ####Rri Method ####RSq Method ####RTD Method ####Search Method ####SearchB Method ####Sec Method ####Sech Method ####SeriesSum Method ####Sinh Method ####Skew Method ####Skew_p Method ####Sln Method ####Slope Method ####Small Method ####SqrtPi Method ####Standardize Method ####StDev Method ####StDev_P Method ####StDev_S Method ####StDevP Method ####StEyx Method ####Substitute Method ####Subtotal Method ####Sum Method ####SumIf Method ####SumIfs Method ####SumProduct Method ####SumSq Method ####SumX2MY2 Method ####SumX2PY2 Method ####SumXMY2 Method ####Syd Method ####T_Dist Method ####T_Dist_2T Method ####T_Dist_RT Method ####T_Inv Method ####T_Inv_2T Method ####T_Test Method ####Tanh Method ####TBillEq Method ####TBillPrice Method ####TBillYield Method ####TDist Method ####Text Method ####TInv Method ####Transpose Method ####Trend Method ####Trim Method ####TrimMean Method ####TTest Method ####Unichar Method ####Unicode Method ####USDollar Method ####Var Method ####Var_P Method ####Var_S Method ####VarP Method ####Vdb Method ####VLookup Method ####WebService Method ####Weekday Method ####WeekNum Method ####Weibull Method ####Weibull_Dist Method ####WorkDay Method ####WorkDay_Intl Method ####Xirr Method ####Xnpv Method ####Xor Method ####YearFrac Method ####YieldDisc Method ####YieldMat Method ####Z_Test Method ####ZTest Method ###Worksheets Object ####Application Property ####Count Property ####Creator Property ####HPageBreaks Property ####Item Property ####Parent Property ####Visible Property ####VPageBreaks Property ####Add Method ####Add2 Method ####Copy Method ####Delete Method ####FillAcrossSheets Method ####Move Method ####PrintOut Method ####PrintPreview Method ####Select Method ###WorksheetView Object ####Application Property ####Creator Property ####DisplayFormulas Property ####DisplayGridlines Property ####DisplayHeadings Property ####DisplayOutline Property ####DisplayZeros Property ####Parent Property ####Sheet Property ###XmlDataBinding Object ####Application Property ####Creator Property ####Parent Property ####SourceUrl Property ####ClearSettings Method ####LoadSettings Method ####Refresh Method ###XmlMap Object ####AdjustColumnWidth Property ####AppendOnImport Property ####Application Property ####Creator Property ####DataBinding Property ####IsExportable Property ####Name Property ####Parent Property ####PreserveColumnFilter Property ####PreserveNumberFormatting Property ####RootElementName Property ####RootElementNamespace Property ####SaveDataSourceDefinition Property ####Schemas Property ####ShowImportExportValidationErrors Property ####WorkbookConnection Property ####Delete Method ####Export Method ####ExportXml Method ####Import Method ####ImportXml Method ###XmlMaps Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Add Method ###XmlNamespace Object ####Application Property ####Creator Property ####Parent Property ####Prefix Property ####Uri Property ###XmlNamespaces Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ####Value Property ####InstallManifest Method ###XmlSchema Object ####Application Property ####Creator Property ####Name Property ####Namespace Property ####Parent Property ####XML Property ###XmlSchemas Object ####Application Property ####Count Property ####Creator Property ####Item Property ####Parent Property ###XPath Object ####Application Property ####Creator Property ####Map Property ####Parent Property ####Repeating Property ####Value Property ####Clear Method ####SetValue Method ###Enumerations ####Constants Enumeration ####XlAboveBelow Enumeration ####XlActionType Enumeration ####XlAllocation Enumeration ####XlAllocationMethod Enumeration ####XlAllocationValue Enumeration ####XlApplicationInternational Enumeration ####XlApplyNamesOrder Enumeration ####XlArabicModes Enumeration ####XlArrangeStyle Enumeration ####XlArrowHeadLength Enumeration ####XlArrowHeadStyle Enumeration ####XlArrowHeadWidth Enumeration ####XlAutoFillType Enumeration ####XlAutoFilterOperator Enumeration ####XlAxisCrosses Enumeration ####XlAxisGroup Enumeration ####XlAxisType Enumeration ####XlBackground Enumeration ####XlBarShape Enumeration ####XlBinsType Enumeration ####XlBordersIndex Enumeration ####XlBorderWeight Enumeration ####XlBuiltInDialog Enumeration ####XlCalcFor Enumeration ####XlCalcMemNumberFormatType Enumeration ####XlCalculatedMemberType Enumeration ####XlCalculation Enumeration ####XlCalculationInterruptKey Enumeration ####XlCalculationState Enumeration ####XlCategoryLabelLevel Enumeration ####XlCategoryType Enumeration ####XlCellChangedState Enumeration ####XlCellInsertionMode Enumeration ####XlCellType Enumeration ####XlChartElementPosition Enumeration ####XlChartGallery Enumeration ####XlChartItem Enumeration ####XlChartLocation Enumeration ####XlChartPicturePlacement Enumeration ####XlChartPictureType Enumeration ####XlChartSplitType Enumeration ####XlChartType Enumeration ####XlCheckInVersionType Enumeration ####XlClipboardFormat Enumeration ####XlCmdType Enumeration ####XlColorIndex Enumeration ####XlColumnDataType Enumeration ####XlCommandUnderlines Enumeration ####XlCommentDisplayMode Enumeration ####XlConditionValueTypes Enumeration ####XlConnectionType Enumeration ####XlConsolidationFunction Enumeration ####XlContainsOperator Enumeration ####XlCopyPictureFormat Enumeration ####XlCorruptLoad Enumeration ####XlCreator Enumeration ####XlCredentialsMethod Enumeration ####XlCubeFieldSubType Enumeration ####XlCubeFieldType Enumeration ####XlCutCopyMode Enumeration ####XlCVError Enumeration ####XlDataBarAxisPosition Enumeration ####XlDataBarBorderType Enumeration ####XlDataBarFillType Enumeration ####XlDataBarNegativeColorType Enumeration ####XlDataLabelPosition Enumeration ####XlDataLabelSeparator Enumeration ####XlDataLabelsType Enumeration ####XlDataSeriesDate Enumeration ####XlDataSeriesType Enumeration ####XlDeleteShiftDirection Enumeration ####XlDirection Enumeration ####XlDisplayBlanksAs Enumeration ####XlDisplayDrawingObjects Enumeration ####XlDisplayUnit Enumeration ####XlDupeUnique Enumeration ####XlDVAlertStyle Enumeration ####XlDVType Enumeration ####XlDynamicFilterCriteria Enumeration ####XlEditionFormat Enumeration ####XlEditionOptionsOption Enumeration ####XlEditionType Enumeration ####XlEnableCancelKey Enumeration ####XlEnableSelection Enumeration ####XlEndStyleCap Enumeration ####XlErrorBarDirection Enumeration ####XlErrorBarInclude Enumeration ####XlErrorBarType Enumeration ####XlErrorChecks Enumeration ####XlFileAccess Enumeration ####XlFileFormat Enumeration ####XlFileValidationPivotMode Enumeration ####XlFillWith Enumeration ####XlFilterAction Enumeration ####XlFilterAllDatesInPeriod Enumeration ####XlFilterStatus Enumeration ####XlFindLookIn Enumeration ####XlFixedFormatQuality Enumeration ####XlFixedFormatType Enumeration ####XlForecastAggregation Enumeration ####XlForecastChartType Enumeration ####XlForecastDataCompletion Enumeration ####XlFormatConditionOperator Enumeration ####XlFormatConditionType Enumeration ####XlFormatFilterTypes Enumeration ####XlFormControl Enumeration ####XlFormulaLabel Enumeration ####XlGenerateTableRefs Enumeration ####XlGradientFillType Enumeration ####XlHAlign Enumeration ####XlHebrewModes Enumeration ####XlHighlightChangesTime Enumeration ####XlHtmlType Enumeration ####XlIcon Enumeration ####XlIconSet Enumeration ####XlIMEMode Enumeration ####XlImportDataAs Enumeration ####XlInsertFormatOrigin Enumeration ####XlInsertShiftDirection Enumeration ####XlLayoutFormType Enumeration ####XlLayoutRowType Enumeration ####XlLegendPosition Enumeration ####XlLineStyle Enumeration ####XlLink Enumeration ####XlLinkInfo Enumeration ####XlLinkInfoType Enumeration ####XlLinkStatus Enumeration ####XlLinkType Enumeration ####XlListConflict Enumeration ####XlListDataType Enumeration ####XlListObjectSourceType Enumeration ####XlLocationInTable Enumeration ####XlLookAt Enumeration ####XlLookFor Enumeration ####XlMailSystem Enumeration ####XlMarkerStyle Enumeration ####XlMeasurementUnits Enumeration ####XlModelChangeSource Enumeration ####XlMouseButton Enumeration ####XlMousePointer Enumeration ####XlMSApplication Enumeration ####XlOartHorizontalOverflow Enumeration ####XlOartVerticalOverflow Enumeration ####XlObjectSize Enumeration ####XlOLEType Enumeration ####XlOLEVerb Enumeration ####XlOrder Enumeration ####XlOrientation Enumeration ####XlPageBreak Enumeration ####XlPageBreakExtent Enumeration ####XlPageOrientation Enumeration ####XlPaperSize Enumeration ####XlParameterDataType Enumeration ####XlParameterType Enumeration ####XlParentDataLabelOptions Enumeration ####XlPasteSpecialOperation Enumeration ####XlPasteType Enumeration ####XlPattern Enumeration ####XlPhoneticAlignment Enumeration ####XlPhoneticCharacterType Enumeration ####XlPictureAppearance Enumeration ####XlPictureConvertorType Enumeration ####XlPieSliceIndex Enumeration ####XlPieSliceLocation Enumeration ####XlPivotCellType Enumeration ####XlPivotConditionScope Enumeration ####XlPivotFieldCalculation Enumeration ####XlPivotFieldDataType Enumeration ####XlPivotFieldOrientation Enumeration ####XlPivotFieldRepeatLabels Enumeration ####XlPivotFilterType Enumeration ####XlPivotFormatType Enumeration ####XlPivotLineType Enumeration ####XlPivotTableMissingItems Enumeration ####XlPivotTableSourceType Enumeration ####XlPivotTableVersionList Enumeration ####XlPlacement Enumeration ####XlPlatform Enumeration ####XlPortugueseReform Enumeration ####XlPrintErrors Enumeration ####XlPrintLocation Enumeration ####XlPriority Enumeration ####XlPropertyDisplayedIn Enumeration ####XlProtectedViewCloseReason Enumeration ####XlProtectedViewWindowState Enumeration ####XlPTSelectionMode Enumeration ####XlQueryType Enumeration ####XlQuickAnalysisMode Enumeration ####XlRangeAutoFormat Enumeration ####XlRangeValueDataType Enumeration ####XlReferenceStyle Enumeration ####XlReferenceType Enumeration ####XlRemoveDocInfoType Enumeration ####XlRgbColor Enumeration ####XlRobustConnect Enumeration ####XlRoutingSlipDelivery Enumeration ####XlRoutingSlipStatus Enumeration ####XlRowCol Enumeration ####XlRunAutoMacro Enumeration ####XlSaveAction Enumeration ####XlSaveAsAccessMode Enumeration ####XlSaveConflictResolution Enumeration ####XlScaleType Enumeration ####XlSearchDirection Enumeration ####XlSearchOrder Enumeration ####XlSearchWithin Enumeration ####XlSeriesNameLevel Enumeration ####XlSheetType Enumeration ####XlSheetVisibility Enumeration ####XlSizeRepresents Enumeration ####XlSlicerCacheType Enumeration ####XlSlicerCrossFilterType Enumeration ####XlSlicerSort Enumeration ####XlSmartTagControlType Enumeration ####XlSmartTagDisplayMode Enumeration ####XlSortDataOption Enumeration ####XlSortMethod Enumeration ####XlSortMethodOld Enumeration ####XlSortOn Enumeration ####XlSortOrder Enumeration ####XlSortOrientation Enumeration ####XlSortType Enumeration ####XlSourceType Enumeration ####XlSpanishModes Enumeration ####XlSparklineRowCol Enumeration ####XlSparkScale Enumeration ####XlSparkType Enumeration ####XlSpeakDirection Enumeration ####XlSpecialCellsValue Enumeration ####XlStdColorScale Enumeration ####XlSubscribeToFormat Enumeration ####XlSubtototalLocationType Enumeration ####XlSummaryColumn Enumeration ####XlSummaryReportType Enumeration ####XlSummaryRow Enumeration ####XlTableStyleElementType Enumeration ####XlTabPosition Enumeration ####XlTextParsingType Enumeration ####XlTextQualifier Enumeration ####XlTextVisualLayoutType Enumeration ####XlThemeColor Enumeration ####XlThemeFont Enumeration ####XlThreadMode Enumeration ####XlTickLabelOrientation Enumeration ####XlTickLabelPosition Enumeration ####XlTickMark Enumeration ####XlTimelineLevel Enumeration ####XlTimePeriods Enumeration ####XlTimeUnit Enumeration ####XlToolbarProtection Enumeration ####XlTopBottom Enumeration ####XlTotalsCalculation Enumeration ####XlTrendlineType Enumeration ####XlUnderlineStyle Enumeration ####XlUpdateLinks Enumeration ####XlVAlign Enumeration ####XlWBATemplate Enumeration ####XlWebFormatting Enumeration ####XlWebSelectionType Enumeration ####XlWindowState Enumeration ####XlWindowType Enumeration ####XlWindowView Enumeration ####XlXLMMacroType Enumeration ####XlXmlExportResult Enumeration ####XlXmlImportResult Enumeration ####XlXmlLoadOption Enumeration ####XlYesNoGuess Enumeration ##Microsoft Graph Visual Basic reference ###Collections ####Axes Collection ####ChartGroups Collection ####DataLabels Collection ####HiLoLines Object ####LegendEntries Collection ####Points Collection ####SeriesCollection Collection ####Trendlines Collection ###Objects ####Application Object ####AutoCorrect Object ####Axis Object ####AxisTitle Object ####Border Object ####Chart Object ####ChartArea Object ####ChartColorFormat Object ####ChartFillFormat Object ####ChartGroup Object ####ChartTitle Object ####Corners Object ####DataLabel Object ####DataSheet Object ####DataTable Object ####DisplayUnitLabel Object ####DownBars Object ####DropLines Object ####ErrorBars Object ####Floor Object ####Font Object ####Gridlines Object ####Interior Object ####LeaderLines Object ####Legend Object ####LegendEntry Object ####LegendKey Object ####PlotArea Object ####Point Object ####Range Object ####Series Object ####SeriesLines Object ####TickLabels Object ####Trendline Object ####UpBars Object ####Walls Object ####Activate Method ####Add Method ####AddChartAutoFormat Method ####AddReplacement Method ####ApplyCustomType Method ####ApplyDataLabels Method ####AreaGroups Method ####AutoFit Method ####Axes Method ####BarGroups Method ####Chart Method ####ChartGroups Method ####Clear Method ####ClearContents Method ####ClearFormats Method ####ColumnGroups Method ####Copy Method ####Cut Method ####DataLabels Method ####Delete Method ####DeleteChartAutoFormat Method ####DeleteReplacement Method ####Deselect Method ####DoughnutGroups Method ####ErrorBar Method ####Evaluate Method ####Export Method ####FileImport Method ####Insert Method ####Item Method ####LegendEntries Method ####LineGroups Method ####OneColorGradient Method ####Paste Method ####Patterned Method ####PieGroups Method ####Points Method ####PresetGradient Method ####PresetTextured Method ####Quit Method ####RadarGroups Method ####Refresh Method ####SaveAs Method ####SaveAsOldFileFormat Method ####SeriesCollection Method ####SetDefaultChart Method ####SetEchoOn Method ####Solid Method ####Trendlines Method ####TwoColorGradient Method ####Update Method ####UserPicture Method ####UserTextured Method ####XYGroups Method ####Application Property ####ApplyPictToEnd Property ####ApplyPictToFront Property ####ApplyPictToSides Property ####Area3DGroup Property ####AutoCorrect Property ####AutoScaleFont Property ####AutoScaling Property ####AutoText Property ####AxisBetweenCategories Property ####AxisGroup Property ####AxisTitle Property ####BackColor Property ####Background Property ####Backward Property ####Bar3DGroup Property ####BarShape Property ####BaseUnit Property ####BaseUnitIsAuto Property ####Bold Property ####Border Property ####BubbleScale Property ####CapitalizeNamesOfDays Property ####Caption Property ####CategoryType Property ####CellDragAndDrop Property ####Cells Property ####ChartArea Property ####ChartTitle Property ####ChartType Property ####Color Property ####ColorIndex Property ####Colors Property ####Column3DGroup Property ####Columns Property ####ColumnWidth Property ####CommandBars Property ####Corners Property ####CorrectCapsLock Property ####CorrectSentenceCap Property ####Count Property ####Creator Property ####Crosses Property ####CrossesAt Property ####DataLabel Property ####DataSheet Property ####DataTable Property ####DepthPercent Property ####DisplayAlerts Property ####DisplayAutoCorrectOptions Property ####DisplayBlanksAs Property ####DisplayEquation Property ####DisplayRSquared Property ####DisplayUnit Property ####DisplayUnitCustom Property ####DisplayUnitLabel Property ####DoughnutHoleSize Property ####DownBars Property ####DropLines Property ####Elevation Property ####EndStyle Property ####ErrorBars Property ####Explosion Property ####Fill Property ####FirstSliceAngle Property ####Floor Property ####Font Property ####FontStyle Property ####ForeColor Property ####Forward Property ####GapDepth Property ####GapWidth Property ####GradientColorType Property ####GradientDegree Property ####GradientStyle Property ####GradientVariant Property ####Has3DEffect Property ####Has3DShading Property ####HasAxis Property ####HasBorderHorizontal Property ####HasBorderOutline Property ####HasBorderVertical Property ####HasDataLabel Property ####HasDataLabels Property ####HasDataTable Property ####HasDisplayUnitLabel Property ####HasDropLines Property ####HasErrorBars Property ####HasHiLoLines Property ####HasLeaderLines Property ####HasLegend Property ####HasLinks Property ####HasMajorGridlines Property ####HasMinorGridlines Property ####HasRadarAxisLabels Property ####HasSeriesLines Property ####HasTitle Property ####HasUpDownBars Property ####Height Property ####HeightPercent Property ####HiLoLines Property ####HorizontalAlignment Property ####Include Property ####Index Property ####InsideHeight Property ####InsideLeft Property ####InsideTop Property ####InsideWidth Property ####Intercept Property ####InterceptIsAuto Property ####Interior Property ####InvertIfNegative Property ####Italic Property ####Item Property ####LeaderLines Property ####Left Property ####Legend Property ####LegendKey Property ####Line3DGroup Property ####LineStyle Property ####MajorGridlines Property ####MajorTickMark Property ####MajorUnit Property ####MajorUnitIsAuto Property ####MajorUnitScale Property ####MarkerBackgroundColor Property ####MarkerBackgroundColorIndex Property ####MarkerForegroundColor Property ####MarkerForegroundColorIndex Property ####MarkerSize Property ####MarkerStyle Property ####MaximumScale Property ####MaximumScaleIsAuto Property ####MinimumScale Property ####MinimumScaleIsAuto Property ####MinorGridlines Property ####MinorTickMark Property ####MinorUnit Property ####MinorUnitIsAuto Property ####MinorUnitScale Property ####MoveAfterReturn Property ####Name Property ####NameIsAuto Property ####NumberFormat Property ####NumberFormatLocal Property ####Offset Property ####Order Property ####Orientation Property ####OutlineFont Property ####Overlap Property ####Parent Property ####Pattern Property ####PatternColor Property ####PatternColorIndex Property ####Period Property ####Perspective Property ####PictureType Property ####PictureUnit Property ####Pie3DGroup Property ####PlotArea Property ####PlotBy Property ####PlotOnX Property ####Position Property ####PresetGradientType Property ####PresetTexture Property ####RadarAxisLabels Property ####Range Property ####ReadingOrder Property ####ReplacementList Property ####ReplaceText Property ####ReversePlotOrder Property ####RGB Property ####RightAngleAxes Property ####Rotation Property ####Rows Property ####ScaleType Property ####SchemeColor Property ####SecondaryPlot Property ####SecondPlotSize Property ####Separator Property ####SeriesLines Property ####Shadow Property ####ShowBubbleSize Property ####ShowCategoryName Property ####ShowChartTipNames Property ####ShowChartTipValues Property ####ShowLegendKey Property ####ShowNegativeBubbles Property ####ShowPercentage Property ####ShowSeriesName Property ####ShowValue Property ####Size Property ####SizeRepresents Property ####Smooth Property ####SplitType Property ####SplitValue Property ####Strikethrough Property ####Subscript Property ####Superscript Property ####SurfaceGroup Property ####Text Property ####TextureName Property ####TextureType Property ####TickLabelPosition Property ####TickLabels Property ####TickLabelSpacing Property ####TickMarkSpacing Property ####Top Property ####TwoInitialCapitals Property ####Type Property ####Underline Property ####UpBars Property ####Value Property ####VaryByCategories Property ####Version Property ####VerticalAlignment Property ####Visible Property ####Walls Property ####WallsAndGridlines2D Property ####Weight Property ####Width Property ####WindowState Property ###Enumerations