Microsoft Corp. Office 2003 Editions: Excel VBA Language Reference

Microsoft Corp., 2004.
(Автор и количество страниц не указаны).This download contains documentation (such as programming references and technical articles), and may contain tools and sample code designed to help you customize Microsoft Office Excel 2003 and to extend Word and integrate with other applications.
Источник: сайт www.microsoft.com
Разработано для версии MS Excel 2003, но, в целом, применимо для более ранних и более поздних версий.Foreword.
Microsoft Excel Visual Basic Reference.
Welcome to the Microsoft Excel 2003 VBA Language Reference.
Microsoft Excel Object Model.
What's New.
New Objects.
New Properties (Alphabetic List).
New Properties (by Object).
New Methods (Alphabetic List).
New Methods (by Object).
New Events.
Concepts.
Workbooks and Worksheets.
Creating a New Workbook.
Opening a Workbook.
Referring to Sheetsby Index Number.
Referring to Sheetsby Name.
Saving Documents as Web Pages.
Cells and Ranges.
How to Reference Cells and Ranges.
Looping Through a Range of Cells.
Selecting and Activating Cells.
Working with 3-D Ranges.
Working with the Active Cell.
Controls, Dialog Boxes, and Forms.
Using ActiveX Controls on Sheets.
Using ActiveX Controls on a Document.
Creating a Custom Dialog Box.
Using Microsoft Office Web Components on Forms.
Built-In Dialog Box Argument Lists.
Events, Worksheet Functions, and Shapes.
Using Events with Microsoft Excel Objects.
Using Microsoft Excel Worksheet Functions in Visual Basic.
Working with Shapes (Drawing Objects).
List of Worksheet Functions Available to Visual Basic.
Working with Other Applications.
Controlling One Microsoft Office Application from Another.
OLE Programmatic Identfiers.Collections.
AddIns. AllowEditRanges. Areas. Axes. Borders. CalculatedFields. CalculatedItems. CalculatedMembers. ChartGroups. ChartObjects. Charts. Comments. CubeFields. CustomProperties. CustomViews. DataLabels. DiagramNodes. Dialogs. Errors. Filters. FormatConditions. HPageBreaks. Hyperlinks. LegendEntries. ListColumns. ListObjects. ListRows. Names. ODBCErrors. OLEDBErrors. OLEObjects. Panes. Parameters. Phonetics. PivotCaches. PivotFields. PivotFormulas. PivotItemList. PivotItems. PivotTables. Points. PublishObjects. QueryTables. Range. RecentFiles. Scenarios. Series. ShapeNodes. ShapeRange. Shapes. Sheets. SmartTagActions. SmartTagRecognizers. SmartTags. Styles. Trendlines. UsedObjects. UserAccessList. VPageBreaks. Watches. Windows. Workbooks. Worksheets. XmlMaps. XmlNamespaces. XmlSchemas.
Objects.
AddIn. Adjustments. Allow EditRange. Application. AutoCorrect. AutoFilter. AutoRecover. Axis. AxisTitle. Border. CalculatedMtember. CalloutFormat. CellFormat. Characters. Chart. ChartArea. ChartColorFormat. ChartFillFormat. ChartGroup. ChartObject. ChartTitle. ColorFormat. Comment. ConnectorFormat. ControlFormat. Corners. CubeField. CustomProperty. CustomView. DataLabel. DataTable. DefaultWebOptions. Diagram. DiagramNode. DiagramNodeChildren. Dialog. DisplayUnitLabel. DownBars. DropLines. ErrorObject. ErrorBars. ErrorCheckingOptions. FillFormat. Filter. Floor. Font. FormatCondition. FreeformBuilder. Graphic. Gridlines. GroupShapes. HiLoLines. HPageBreak. Hyperlink. Interior. IRtdServer. IRTDUpdateEvent. LeaderLines. Legend. LegendEntry. LegendKey. LineFormat. LinkFormat. ListColumn. ListDataFormat. ListObject. ListRow. Mailer. Name. ODBCError. OLEDBError. OLEFormat. OLEObject. Outline. PageSetup. Pane. Parameter. Phonetic. PictureFormat. PivotCache. PivotCell. PivotField. PivotFormula. PivotItem. PivotLayout. PivotTable. PlotArea. Point. Protection. PublishObject. QueryTable. RecentFile. RoutingSlip. RTD. Scenario. Series. SeriesLines. ShadowFormat. Shape. ShapeNode. SmartTag. SmartTagAction. SmartTagOptions. SmartTagRecognizer. SoundNote. Speech. SpellingOptions. Style. Tab. TextEffectFormat. TextFrame. ThreeDFormat. TickLabels. TreeviewControl. Trendline. UpBars. UserAccess. Validation. VPageBreak. Walls. Watch. WebOptions. Window. Workbook. Worksheet. WorksheetFunction. XmlDataBinding. XmlMap. XmlNamespace Obiect. XmlSchema. XPath.
Methods.
AcceptAllChanges. Activate. ActivateMicrosoftApp. ActivateNext. ActivatePrevious. Add. AddCallout. AddChartAutoFormat. AddComment. AddConnector. AddCurve. AddCustomList. AddDataField. AddDiagram. AddFields. AddFormControl. AddItem. AddLabel. AddLine. AddMtemberPropertyField. AddNode. AddNodes. AddOLEObject. AddPageItem. AddPicture. AddPolyline. AddReplacement. AddSet. AddShape. AddTextbox. AddTextEffect. AddToFavorites. AdvancedFilter. Align. Apply. ApplyCustomType. ApplyDataLabels. ApplyNames. ApplyOutlineStyles. AreaGroups. Arrange. AutoComplete. AutoFill. AutoFilter. AutoFit. AutoFormat. AutomaticLength. AutoOutline. AutoShow. AutoSort. Axes. BarGroups. BeginConnect. BeginDisconnecl. BorderAround. BreakLink. BreakSideBySide. BringToFront. BuildFreeform. Calculate. CalculatedFields. CalculatedItems. CalculateFull. CalculateFullRebuild. CancelRefresh. CanCheckIn. CanCheckOut. CentimetersToPolnts. ChangeFileAccess. ChangeLink. ChangePassword. ChangeScenario. Characters. ChartGroups. ChartObjects. ChartWizard. CheckAbort. CheckIn. CheckOut. CheckSpelling. CircleInvalid. Clear. ClearArrows. ClearCircles. ClearComments. ClearContents. ClearFormats. ClearNotes. ClearOutline. ClearSettings. CloneNode Methiod. Close. ColumnDifferences. ColumnGroups. CompareSideBySideWith. ConnectData. Consolidate. Convert. ConvertFormula. ConvertToShape. Copy. CopyFromRecordset. CopyPicture. CreateCubeFile. CreateNames. CreateNewDocument. CreatePivotTable. CreatePublisher. CreateSummary. CustomDrop. CustomLength. Cut. DataLabels. DataSeries. DDEExecute. DDEInitiate. DDEPoke. DDERequest. DDETerminate. Delete. DeleteAll. DeleteChartAutoFormat. DeleteCustomList. DeleteNumberFormat. DeleteReplacement. Deselect. DialogBox. Dirty. Disconnect. DisconnectData. DisplayXMLSourcePane. Distribute. DoubleClick. DoughnutGroups. DragOff. Duplicate. EditionOptions. EndConnect. EndDisconnect. EndReview. ErrorBar. Evaluate. ExclusiveAccess. Execute. ExecuteExcel4Macro. Export. ExportXml. Extend. FillAcrossSheets. FillDown. FillLeft. FillRight. FillUp. Find. FindFile. FindNext. FindPrevious. Flip. Follow. FollowHyperlink. Format. ForwardMailer. FunctionWizard. GetChartElement. GetCustomListContents. GetCustomListNum. GetData. GetOpenFilename. GetPhonetic. GetPivotData. GetSaveAsFilename. GoalSeek. Goto. Group. Heartbeat. Help. HighlightChangesOptions. Import. ImportXml. InchesToPoints. IncrementBrightness. IncrementContrast. IncrementLeft. IncrementOffsetX. IncrementOffsetY. IncrementRotation. IncrementRotationX. IncrementRotationY. IncrementTop. InputBox. Insert. InsertIndent. InstallManifest. Intersect. Item. Justify. LargeScroll. LegendEntries. LineGroups. LinkInfo. LinkSources. List. ListFormulas. ListNames. LoadSettings. Location. MacroOptions. MailLogoff. MailLogon. MakeConnection. Merge. MergeWorkbook. Modify. Move. MoveNode. NavigateArrow. NewSeries. NewWindow. Next. NextLetter. NextNode. NoteText. OLEObjects. OneColorGradient. OnKey. OnRepeat. OnTime. OnUndo. Open. OpenDatabase. OpenLinks. OpenText. OpenXML. Parse. Paste. PasteSpecial. Patterned. PickUp. PieGroups. PivotCache. PivotCaches. PivotFields. PivotItems. PivotSelect. PivotTables. PivotTableWizard. Play. Points. PointsToScreenPixelsX. PointsToScreenPixelsY. Post. PresetDrop. PresetGradient. PresetTextured. Previous. PrevNode. PrintOut. PrintPreview. Protect. ProtectSharing. Publish. PurgeChangeHistoryNow. Quit. RadarGroups. RangeFromPoint. RecheckSmartTags. Record. RecordMacro. Refresh. RefreshAll. RefreshData. RefreshTable. RegisterXLL. Regroup. RejectAllChanges. ReloadAs. RemoveAllItems. RemoveItem. RemoveSubtotal. RemoveUser. Repeat. Replace. ReplaceNode. Reply. ReplyAll. ReplyWithChanges. RerouteConnections. Reset. ResetAllPageBreaks. ResetColors. ResetPositionsSideBySide. ResetRotation. ResetTimer. Resize. RestartServers. Route. Row Differences. RTD. Run. RunAutoMacros. Save. SaveAs. SaveAsODC. SaveAsXMLData. SaveCopyAs. SaveWorkspace. ScaleHeight. ScaleWidth. Scenarios. ScrollIntoView. ScrollWorkbookTabs. Select. SelectAll. SendFaxOverInternet. SendForReview. SendKeys. SendMail. SendMailer. SendToBack. SeriesCollection. ServerStart. ServerTerminate. SetBackgroundPicture. SetDefaultChart. SetEditingType. SetExtrusionDirection. SetLinkOnData. SetParam. SetPasswordEncryptionOptions. SetPhonetic. SetPosition. SetSegmentType. SetShapesDefaultProperties. SetSourceData. SetThreeDFormat. SetValue. ShowMethod. ShowAllData. ShowDataForm. ShowDependents. ShowErrors. ShowLevels. ShowPages. Table. Text. TextToColumns. ToggleVerticalText. TransferChildren. Trendlines. TwoColorGradient. Undo. Ungroup. Union. Unlink. Unlist. UnMerge. Unprotect. UnprotectSharing. Update. UpdateChanges. UpdateFromFile. UpdateLink. UpdateNotify. UseDefaultFolderSuffix. UserPicture. UserTextured. Verb. Volatile. Wait. WebPagePreview. XmlDataQuery. XmlImport. XmlImportXml. XmlMapQuery. XYGroups. ZOrder.
Properties.
Accent. AcceptLabelsInFormuias. Active. ActiveCell. ActiveChart. ActivePane. ActivePrinter. ActiveSheet. ActiveWindow. ActiveWorkbook. ActiveXControl. AddIndent. AddIns. Address. AddressLocal. AdjustColumnWidth. Adjustments. ADOConnection. AlertBeforeOverwriting. AlertStyle. Alignment. AllowDeletingColumns. AllowDeletingRows. AllowEdit. AllowEditRanges. AllowFillIn. AllowFiltering. AllowFormattingCells. AllowFormattingColumns. AllowFormattingRows. AllowInsertingColumns. AllowInsertingHyperlinks. AllowInsertingRows. AllowPNG. AllowSorting. AllowUsingPivolTables. AlternativeText. AltStartupPath. AlwaysSaveInDefaultEncoding. Angle. AnswerWizard. AppendOnImport. Application. ApplyPictToEnd. ApplyPictToFront. ApplyPictToSides. ArabicModes. ArbitraryXMLSupportAvailable. Area3DGroup. Areas. AskToUpdateLinks. Assistant. Author. AutoAttach. AutoCorrect. AutoExpandListRange. AutoFilter. AutoFilterMode. AutoFormat. AutoFormatAsYouTypeReplaceHyperlinks. AutoLayout. AutoLength. AutoLoad. AutoMargins. AutomaticStyles. AutomationSecurity. AutoPercentEntry. AutoRecover. AutoRepublish. AutoScaleFont. AutoScaling. AutoShapeType. AutoShow Count. AutoShow Field. AutoShowRange. AutoShowType. AutoSize. AutoSortField. AutoSortOrder. AutoText. AutoUpdate. AutoUpdateFrequency. AutoUpdateSaveChanges. AxisBetweenCategories. AxisGroup. AxisTitle. BackColor. Background. BackgroundChecking. BackgroundQuery. Backward. Bar3DGroup. BarShape. BaseField. BaseItem. BaseUnit. BaseUnitIsAuto. BCCRecipients. BeginArrowheadLength. BeginArrowheadStyle. BeginArrowheadWidth. BeginConnected. BeginConnected Shape. BeginConnectionSite. BlackAndWhite. BlackWhiteMode. BoldProperty. Border. Borders. BottomMargin. BottomRightCell. Brightness. BubbleScale. BubbleSizes. Build. BuiltIn. BuiltinDocumentProperties. CacheIndex. CalculateBeforeSave. CalculatedMembers. Calculation. CalculationInterruptKey. CalculationState. CalculationVersion. Caller. Callout. CanPlaySounds. CanRecordSounds. CapitalizeNamesOfDays. Caption. Category. CategoryLocal. CategoryNames. CategoryType. CCRecipients. CellDragAndDrop. Cells. CenterFooter. CenterFooterPicture. CenterHeader. CenterHeaderPicture. CenterHorizontally. CenterVertically. ChangeHistoryDuration. ChangingCells. Characters. CharacterType. Chart. ChartArea. Charts. ChartSize. ChartTitle. ChartType. CheckboxState. CheckIfOfficeIsHTMLEditor. Child. ChildField. ChildItems. Children. Choices. CircularReference. ClipboardFormats. CLSID. CodeName. Color. ColorIndex. Colors. ColorType. Column. Column3DGroup. ColumnFields. ColumnGrand. ColumnItems. ColumnRange. Columns. ColumnWidth. COMAddIns. CommandBars. CommandText. CommandType. CommandUnderlines. Comment. Comments. ConflictResolution. Connection. ConnectionSiteCount. Connector. ConnectorFormat. ConsolidationFunction. CbnsolidationOptions. CbnsolidationSources. ConstrainNumeric. Container. Contrast. ControlCharacters. ControlFormat. CopyObjectsWithCells. Corners. CorrectCapsLock. CorrectSentenceCap. Count. CreateBackup. Creator. Criteria1 . Criteria2 . CropBottom. CropLeft. CropRight. CropTop. Crosses. CrossesAt. CubeField. CubeFields. CubeFieldType. CurrentArray. CurrentPage. CurrentPageList. Contents. CurrentPageName. CurrentRegion. Cursor. CursorMovement. CustomDocumentProperties. CustomListCount. CustomProperties. CustomSubtotalFunction. CustomViews. CutCopyMode. DashStyle. DatabaseSort. DataBinding. DataBodyRange. DataEntryMode. DataField. DataFields. DataLabel. DataLabelRange. DataPivotField. DataRange. DataTable. DataType. Date1904 . DDEAppReturnCode. DecimalPlaces. DecimalSeparator. DefaultFilePath. DefaultSaveFormat. DefaultSheetDirection. DefaultValue. DefaultWebOptions. Delivery. Dependents. Depth. DepthPercent. Destination. Diagram. DiagramNode. Dialogs. DictLang. DirectDependents. Direction. DirectPrecedents. DisplayAlerts. DisplayAutoCorrectOptions. DisplayBlanksAs. DisplayClipboardWindow. DisplayCommentIndicator. DisplayDocumentActionTaskPane. DisplayDrawingObjects. DisplayEmptyColumn. DisplayEmptyRow. DisplayEquation. DisplayErrorString. DisplayExcel4Menus. DisplayFormulaBar. DisplayFormulas. DisplayFullScreen. DisplayFunctionToolTips. DisplayGridlines. DisplayHeadings. DisplayHorizontalScrollBar. DisplayImmediateItems. DisplayInkComments. DisplayInsertOptions. DisplayNoteIndicator. DisplayNullString. DisplayOutline. DisplayPageBreaks. DisplayPasteOptions. DisplayRecentFiles. DisplayRightToLeft. DisplayRSquared. DisplayScrollBars. DisplaySmartTags. DisplayStatusBar. DisplayUnit. DisplayUnitCustom. DisplayUnitLabel. DisplayVerticalScrollBar. DisplayWorkbookTabs. DisplayZeros. DivID. DocumentLibraryVersions. DoughnutHoleSize. DownBars. DownloadComponents. DownloadURL. Draft. DragToColumn. DragToData. DragToHide. DragToPage. DragToRow. Drilled. DrilledDown. Drop. DropDownLines. DropLines. DropType. EditDirectlyInCell. EditingType. EditWebPage. Elevation. EmailSubject. EmbedSmartTags. EmptyCellReferences. EnableAnimations. EnableAutoComplete. EnableAutoFilter. EnableAutoRecover. EnableCalculation. EnableCancelKey. Enabled. EnableDataValueEditing. EnableDrilldown. EnableEditing. EnableEvents. EnableFieldDialog. EnableFieldList. EnableItemSelection. EnableMultiplePageItems. EnableOutlining. EnablePivotTable. EnableRefresh. EnableResize. EnableSelection. EnableSound. EnableWizard. Enclosures. Encoding. End. EndArrowheadLength. EndArrowheadStyle. EndArrowheadWldth. EndConnected. EndConnectedShape. EndConnectionSite. EndStyle. EntireColumn. EntireRow. EnvelopeVisible. ErrorBars. ErrorCheckingOptions. ErrorMessage. Errors. ErrorString. ErrorTitle. EvaluateToError. Excel4IntlMacroSheets. Excel4MacroSheets. ExpandHelp. Explosion. ExtendList. Extent. ExtrusionColor. ExtrusionColorType. FeatureInstall. FetchedRowOverflow. FieldNames. FileConverters. FileDialog. FileFind. FileFormat. Filename. FileSearch. Fill. FillAdjacentFormulas. FilterMode. Filters. FindFormat. FirstChild. FirstPageNumber. FirstSliceAngle. FitToPagesTall. FitToPagesWide. FixedDecimal. FixedDecimalPlaces. Floor. FolderSuffix. Font. FontBold. FontItalic. FontName. Fonts. FontSize. FontStyle. FooterMargin. ForeColor. FormatConditions. FormControlType. Formula. Formula1 . Formula2 . FormulaArray. FormulaHidden. FormulaLabel. FormulaLocal. FormulaR1C
1. FormulaR1C1Local. Forward. FreezePanes. FullName. FullNameURLEncoded. Function. GapProperty. GapDepth. GapWidth. GenerateGetPivotData. GermanPostReform. GradientColorType. GradientDegree. GradientStyle. GradientVariant. GrandTotalName. GridlineColor. GridlineColorIndex. GroupItems. GroupLevel. Has3DEffect. Has3DShading. HasArray. HasAutoFormat. HasAxis. HasBorderHorizontal. HasBorderOutline. HasBorderVertical. HasDataLabel. HasDataLabels. HasDataTable. HasDiagram. HasDiagramNode. HasDisplayUnitLabel. HasDropLines. HasErrorBars. HasFormula. HasHiLoLines. HasLeaderLines. HasLegend. HasMajorGridlines. HasMemberProperties. HasMinorGridlines. HasPassword. HasPivotFields. HasRadarAxisLabels. HasRoutingSlip. HasSeriesLines. HasTitle. HasUpDownBars. HeaderMargin. HeaderRowRange. HeartbeatInterval. Hebrew Modes. Height. HeightPercent. Hidden. HiddenFields. HiddenItems. HiddenItemsList. HighlightChangesOnScreen. HiLoLines. Hinstance. HorizontalAlignment. HorizontalFlip. HPageBreaks. HTMLProject. HtmlType. Hwnd. Hyperlink. Hyperlinks. ID. Ignore. IgnoreBlank. IgnoreCaps. IgnoreFileNames. IgnoreMixedDigits. IgnoreRemoteRequests. IMEMode. InactiveListBorderVisible. InCellDropdown. IncludeAlignment. IncludeBorder. IncludeFont. IncludeNumber. IncludePatterns. IncludeProtection. InconsistentFormula. IndentLevel. Index. IndicatorColorIndex. InnerDetail. InputMtessage. InputTitle. InsertRowRange. InsideHeight. InsideLeft. InsideTop. InsideWidth. Installed. Interactive. Intercept. InterceptIsAuto. Interior. International. InvalidData. InvertIfNegative. IsAddin. IsCalculated. IsConnected. IsExportable. IsInplace. IsMtemberProperty. IsPercent. IsValid. Italic. Item. Iteration. KeepChangeHistory. KernedPairs. KoreanCombineAux. KoreanProcessCompound. KoreanUseAutoChangeList. LabelRange. LanguageSettings. LargeChange. LastChild. Layout. LayoutBlankLine. LayoutForm. LayoutPageBreak. LayoutSubtotalLocation. Lcid. LeaderLines. Left. LeftFooter. LeftFooterPicture. LeftHeader. LeftHeaderPicture. LeftMargin. Legend. LegendKey. Length. LibraryPath. Line. Line3DGroup. LineStyle. LinkedCell. LinkFormat. ListChangesOnNewSheet. ListColumns. ListCountProperty. ListDataFormat. ListDataValidation. ListFillRange. ListHeaderRows. ListIndex. ListObject. ListObjects. ListRows. ListSelection. LoadPictures. LocalConnection. Location. LocationInTable. LocationOfComponents. LockAspectRatio. Locked. LockedText. MacroType. MailEnvelope. Mailer. MailSession. MailSystem. MaintainConnection. MajorGridlines. MajorTickMark. MajorUnit. MajorUnitIsAuto. MajorUnitScale. ManualUpdate. Map. MapPaperSize. MarginBottom. MarginLeft. MarginRight. MarginTop. MarkerBackgroundColor. MarkerBackgroundColorIndex. MarkerForegroundColor. MarkerForegroundColorIndex. MarkerSize. MarkerStyle. MathCoprocessorAvailable. Max. MaxChange. MaxCharacters. Maximum. MaximumScale. MaximumScaleIsAuto. MaxIterations. MaxNumber. MDX. MemoryFree. MemoryUsed. MergeArea. MergeCells. MergeLabels. Message. Min. MinimumScale. MinimumScaleIsAuto. MinNumber. MinorGridlines. MinorTickMark. MinorUnit. MinorUnitIsAuto. MinorUnitScale. MissingItemsLimit. MouseAvailable. MoveAfterReturn. MoveAfterReturnDirection. MultiSelect. MultiUserEditing. Name. NameIsAuto. NameLocal. Names. Namespace. Native. NetworkTemplatesPath. New Workbook. Next. Nodes. NormalizedHeight. NullString. Number. NumberAsText. NumberFormat. NumberFormatLinked. NumberFormatLocal. Object. Obscured. ODBCErrors. ODBCTimeout. Offset. OffsetX. OffsetY. OLAP. OLEDBErrors. OLEFormat. OLEType. OmittedCells. On. OnAction. OnWindow. OperatingSystem. Operator. OptimizeCache. Order. OrganizationName. OrganizeInFolder. Orientation. Outline. OutlineFont. OutlineLevel. Overlap. PageBreakProperty. PageFieldOrder. PageFields. PageFieldStyle. PageFieldWrapCount. PageRange. PageRangeCells. PageSetup. Panes. PaperSize. Parameters. Parent. ParentField. ParentGroup. ParentItem. ParentItems. ParentShow Detaii. Password. PasswordEncryptionAlgorithm. PasswordEncryptionFileProperties. PasswordEncryptionKeyLength. PasswordEncryptionProvider. Path. PathSeparator. Pattern. PatternColor. PatternColorIndex. Period. Permission. PersonalViewListSettings. PersonalViewPrintSettings. Perspective. Phonetic. PhoneticCharacters. Phonetics. PictureFormat. PictureType. PictureUnit. Pie3DGroup. PivotCell. PivotCellType. PivotField. PivotFields. PivotFormulas. PivotItem. PivotLayout. PivotSelection. PivotSelectionStandard. PivotTable. PivotTableSelection. PixelsPerInch. Placement. PlotArea. PlotBy. PlotOrder. PlotVisibleOnly. Points. Position. PostText. Precedents. PrecisionAsDisplayed. Prefix. PrefixCharacter. PresentInPane. PreserveColumnFilter. PreserveColumnInfo. PreserveFormatting. PreserveNumberFormatting. PresetExtrusionDirection. PresetGradientType. PresetLightingDirection. PresetLightingSoftness. PresetMaterial. PresetShape. PresetTextEffect. PresetTexture. PresetThreeDFormat. Previous. PreviousSelections. PrintArea. PrintComments. PrintErrors. PrintGridlines. PrintHeadings. PrintNotes. PrintObject. PrintQuality. PrintSettings. PrintTitleColumns. PrintTitleRows. PrintTitles. ProductCode. ProgID. PromptForSummaryInfo. PromptString. Properties. PropertyOrder. PropertyParentField. ProtectChartObject. ProtectContents. ProtectData. ProtectDrawingObjects. ProtectFormatting. ProtectGoalSeek. Protection. ProtectionMode. ProtectScenarios. ProtectSelection. ProtectStructure. ProtectWindows. PublishObjects. QueryTable. QueryTables. QueryType. RadarAxisLabels. RadioGroupSelection. Range. RangeSelection. ReadingOrder. ReadOnly. ReadOnlyRecommended. Ready. Received. RecentFiles. Recipients. Recognize. RecordCount. RecordRelative. Recordset. ReferenceStyle. RefersTo. RefersToLocal. RefersToR1C
1. RefersToR1C1 Local. RefersToRange. RefreshDate. Refreshing. RefreshName. RefreshOnChange. RefreshOnFileOpen. RefreshPeriod. RefreshStyle. RegisteredFunctions. RelyOnCSS. RelyOnVML. RemovePersonalInformation. Repeating. RepeatItemsOn EachPrintedPage. ReplaceFormat. ReplacementList. ReplaceText. Required. Resize. ResultRange. ReturnWhenDone. Reverse. ReversePlotOrder. RevisionNumber. RGB. RightAngleAxes. RightFooter. RightFooterPicture. RightHeader. RightHeaderPicture. RightMargin. RobustConnect. RollZoom. Root. RootElementName. RootElementNamespace. RotatedChars. Rotation. RotationX. RotationY. RoundedCorners. Routed. RoutingSlip. Row. RowColSettings. RowFields. RowGrand. RowHeight. RowItems. RowNumbers. RowRange. Rows. RTD. Saved. SaveData. SaveDataSourceDefinition. SaveHiddenData. SaveLinkValues. SaveNewWebPagesAsWebArchives. SavePassword. ScaleType. Schemas. SchemeColor. ScreenSize. ScreenTip. ScreenUpdating. Script. Scripts. ScrollArea. ScrollColumn. ScrollRow. SecondaryPlot. SecondPlotSize. SegmentType. SelectedSheets. Selection. SelectionMode. SendDateTime. Sender. Separator. SeriesLines. ServerBased. Shadow. Shape. ShapeRange. Shapes. SharedWorkspace. SharePointFormula. SharePointURL. Sheet. Sheets. SheetsInNewWorkbook. ShortcutKey. ShowAllItems. ShowAutoFilter. ShowBubbleSize. ShowCategoryName. Show CellBackgroundFromOLAP. ShowChartTipNames. ShowChartTipValues. ShowConflictHistory. ShowDetail. ShowError. ShowImportExportValidationErrors. ShowInFieldList. ShowInput. ShowLegendKey. ShowNegativeBubbles. ShowPageMultlpleItemLabel. ShowPercentage. ShowPivotTableFieldList. ShowSeriesName. ShowStartupDialog. ShowToolTips. ShowTotals. ShowValue. ShowWindow. ShowWindowsInTaskbar. ShrinkToFit. Size. SizeRepresents. SizeWithWindow. SmallChange. SmallGrid. SmartDocument. SmartTagActions. SmartTagOptions. SmartTagRecognizers. SmartTags. Smooth. SolveOrder. SoundNote. Source. SourceConnectionFile. SourceData. SourceDataFile. SourceName. SourceNameStandard. SourceRange. SourceType. SourceUrl. SpeakCellOnEnter. Speech. SpellingOptions. Split. SplitColumn. SplitHorizontal. SplitRow. SplitType. SplitValue. SplitVertical. SqlState. Stage. StandardFont. StandardFontSize. StandardFormula. StandardHeight. StandardWidth. Start. StartupPath. Status. StatusBar. Strikethrough. Style. Styles. SubAddress. Subject. Subscript. SubtotalHiddenPageItems. SubtotalName. Subtotals. SuggestMainOnly. Summary. SummaryColumn. SummaryRow. Superscript. SurfaceGroup. Sync. SyncScrollingSideBySide. Tab. TableRange1 . TableRange2 . TableStyle. TabRatio. Tag. TargetBrowser. TemplateRemoveExtData. TemplatesPath. Text. TextboxText. TextDate. TextEffect. TextFileColumnDataTypes. TextFileCommaDelimiter. TextFileConsecutiveDelimiter. TextFileDecimal Separator. TextFileFixedColumnWldths. TextFileOtherDelimiter. TextFileParseType. TextFilePlatform. TextFilePromptOnRefresh. TextFileSemicolonDelimiter. TextFileSpaceDelimlter. TextFileStartRow. TextFileTabDelimiter. TextFileTextQualifier. TextFileThousandsSeparator. TextFileTrailingMinusNumbers. TextFileVisualLayout. TextFrame. TextShape. TextToDisplay. TextureName. TextureType. ThisCell. ThisWorkbook. ThousandsSeparator. ThreeD. ThrottleInterval. TickLabelPosition. TickLabels. TickLabelSpacing. TickMarkSpacing. Time. TintAndShade. Title. TopProperty. TopLeftCell. TopMargin. ToRecipients. TotalLevels. TotalsAnnotation. TotalsCalculation. TotalsRow Range. Tracking. TrackStatus. TransitionExpEval. TransitionFormEntry. TransitionMenu Key. TransitionMenuKeyAction. TransitionNavigKeys. Transparency. TransparencyColor. TransparentBackground. TreeviewControl. TwoInitialCapitals. Type. Underline. UnlockedFormulaCells. UpBars. UpdateLinks. UpdateLinksOnSave. UpdateRemoteReferences. Uri. UsableHeight. UsableWidth. UsedObjects. UsedRange. UseLocalConnection. UseLongFileNames. UserControl. UserDict. UserLibraryPath. UserName. Users. UserStatus. UseStandardHeight. UseStandardWidth. UseSystemSeparators. VacatedStyle. Validation. Value. Value2 . Values. VaryByCategories. VBASigned. VBE. VBProject. Version. VerticalAlignment. VerticalFlip. Vertices. View. ViewCalculatedMembers. Visible. VisibleFields. VisibleItems. VisibleRange. VisualTotals. VPageBreaks. Walls. WallsAndGridlines2D. Watches. WebConsecutiveDelimitersAsOne. WebDisableDateRecognition. WebDisableRedirections. WebFormatting. WebOptions. WebPreFormattedTextToColumns. WebSelectionType. WebSingleBlockTextImport. WebTables. Weight. WhichAddress. Width. Wndow Number. Wndows. WndowsForPens. Wndow State. Workbooks. Worksheet. WorksheetFunction. Worksheets. WrapText. WritePassword. WriteReserved. WriteReservedBy. XML. XmlMap. XmlMaps. XmlNamespaces. XPath. XValues. Zoom. ZOrder. ZOrderPosition.
Events.
Activate. AddinInstall. AddinUninstall. AfterRefresh. AfterXmlExport. AfterXmlImport. BeforeClose. BeforeDoubleClick. BeforePrint. BeforeRefresh. BeforeRightClick. BeforeSave. BeforeXmlExport. BeforeXmlImport. Calculate. Change. Deactivate. DragOver. DragPlot. Follow Hyperlink. GotFocus. LostFocus. MouseDown. MouseMove. MouseUp. NewSheet. NewWorkbook. Open. PivotTableCloseConnection. PivotTableOpenConnection. PivotTableUpdate. Resize. Select. SelectionChange. SeriesChange. SheetActivate. SheetBeforeDoubleClick. SheetBeforeRightClick. SheetCalculate. SheetChange. SheetDeactivate. SheetFollowHyperlink. SheetPivotTableUpdate. SheetSelectionChange. Sync. Window Activate. Window Deactivate. Window Resize. WorkbookActivate. WorkbookAddinInstall. WorkbookAddinUninstall. WorkbookAfterXml Export. WorkbookAfterXmlImport. WorkbookBeforeClose. WorkbookBeforePrint. WorkbookBeforeSave. WorkbookBeforeXmlExport. WorkbookBeforeXmlImport. WorkbookDeactivate. WorkbookNewSheet. WorkbookOpen. WorkbookPivotTableCloseConnection. WorkbookPivotTableOpenConnection. WorkbookSync.
Enumerations.
Microsoft Excel Constants.