susingshortcutnotation1 v03 Visual Basic Reference
Table of contents
-
Microsoft Excel Visual Basic Reference
- Microsoft Excel Object Model
- What's New
- Programming Concepts
- Collections
-
Objects
- A
- B
-
C
- CalculatedMember Object
- CalloutFormat Object
- CellFormat Object
- Characters Object
- Chart Object
- ChartArea Object
- ChartColorFormat Object
- ChartFillFormat Object
- ChartGroup Object
- ChartObject Object
- ChartTitle Object
- ColorFormat Object
- Comment Object
- ConnectorFormat Object
- ControlFormat Object
- Corners Object
- CubeField Object
- CustomProperty Object
- CustomView Object
- D
- E
- F
- G
- H
- I
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
-
Methods
-
A
- AcceptAllChanges Method
- Activate Method
- ActivateMicrosoftApp Method
- ActivateNext Method
- ActivatePrevious Method
- Add Method
- AddCallout Method
- AddChartAutoFormat Method
- AddComment Method
- AddConnector Method
- AddCurve Method
- AddCustomList Method
- AddDataField Method
- AddDiagram Method
- AddFields Method
- AddFormControl Method
- AddItem Method
- AddLabel Method
- AddLine Method
- AddMemberPropertyField Method
- AddNode Method
- AddNodes Method
- AddOLEObject Method
- AddPageItem Method
- AddPicture Method
- AddPolyline Method
- AddReplacement Method
- AddSet Method
- AddShape Method
- AddTextbox Method
- AddTextEffect Method
- AddToFavorites Method
- AdvancedFilter Method
- Align Method
- Apply Method
- ApplyCustomType Method
- ApplyDataLabels Method
- ApplyNames Method
- ApplyOutlineStyles Method
- AreaGroups Method
- Arrange Method
- AutoComplete Method
- AutoFill Method
- AutoFilter Method
- AutoFit Method
- AutoFormat Method
- AutomaticLength Method
- AutoOutline Method
- AutoShow Method
- AutoSort Method
- Axes Method
- B
-
C
- Calculate Method
- CalculatedFields Method
- CalculatedItems Method
- CalculateFull Method
- CalculateFullRebuild Method
- CancelRefresh Method
- CanCheckIn Method
- CanCheckOut Method
- CentimetersToPoints Method
- ChangeFileAccess Method
- ChangeLink Method
- ChangePassword Method
- ChangeScenario Method
- Characters Method
- ChartGroups Method
- ChartObjects Method
- ChartWizard Method
- CheckAbort Method
- CheckIn Method
- CheckOut Method
- CheckSpelling Method
- CircleInvalid Method
- Clear Method
- ClearArrows Method
- ClearCircles Method
- ClearComments Method
- ClearContents Method
- ClearFormats Method
- ClearNotes Method
- ClearOutline Method
- ClearSettings Method
- CloneNode Method
- Close Method
- ColumnDifferences Method
- ColumnGroups Method
- CompareSideBySideWith Method
- ConnectData Method
- Consolidate Method
- Convert Method
- ConvertFormula Method
- ConvertToShape Method
- Copy Method
- CopyFromRecordset Method
- CopyPicture Method
- CreateCubeFile Method
- CreateNames Method
- CreateNewDocument Method
- CreatePivotTable Method
- CreatePublisher Method
- CreateSummary Method
- CustomDrop Method
- CustomLength Method
- Cut Method
-
D
- DataLabels Method
- DataSeries Method
- DDEExecute Method
- DDEInitiate Method
- DDEPoke Method
- DDERequest Method
- DDETerminate Method
- Delete Method
- DeleteAll Method
- DeleteChartAutoFormat Method
- DeleteCustomList Method
- DeleteNumberFormat Method
- DeleteReplacement Method
- Deselect Method
- DialogBox Method
- Dirty Method
- Disconnect Method
- DisconnectData Method
- DisplayXMLSourcePane Method
- Distribute Method
- DoubleClick Method
- DoughnutGroups Method
- DragOff Method
- Duplicate Method
- E
- F
- G
- H
-
I
- Import Method
- ImportXml Method
- InchesToPoints Method
- IncrementBrightness Method
- IncrementContrast Method
- IncrementLeft Method
- IncrementOffsetX Method
- IncrementOffsetY Method
- IncrementRotation Method
- IncrementRotationX Method
- IncrementRotationY Method
- IncrementTop Method
- InputBox Method
- Insert Method
- InsertIndent Method
- InstallManifest Method
- Intersect Method
- Item Method
- J
- L
- M
- N
- O
-
P
- Parse Method
- Paste Method
- PasteSpecial Method
- Patterned Method
- PickUp Method
- PieGroups Method
- PivotCache Method
- PivotCaches Method
- PivotFields Method
- PivotItems Method
- PivotSelect Method
- PivotTables Method
- PivotTableWizard Method
- Play Method
- Points Method
- PointsToScreenPixelsX Method
- PointsToScreenPixelsY Method
- Post Method
- PresetDrop Method
- PresetGradient Method
- PresetTextured Method
- Previous Method
- PrevNode Method
- PrintOut Method
- PrintPreview Method
- Protect Method
- ProtectSharing Method
- Publish Method
- PurgeChangeHistoryNow Method
- Q
-
R
- RadarGroups Method
- RangeFromPoint Method
- RecheckSmartTags Method
- Record Method
- RecordMacro Method
- Refresh Method
- RefreshAll Method
- RefreshData Method
- RefreshTable Method
- RegisterXLL Method
- Regroup Method
- RejectAllChanges Method
- ReloadAs Method
- RemoveAllItems Method
- RemoveItem Method
- RemoveSubtotal Method
- RemoveUser Method
- Repeat Method
- Replace Method
- ReplaceNode Method
- Reply Method
- ReplyAll Method
- ReplyWithChanges Method
- RerouteConnections Method
- Reset Method
- ResetAllPageBreaks Method
- ResetColors Method
- ResetPositionsSideBySide Method
- ResetRotation Method
- ResetTimer Method
- Resize Method
- RestartServers Method
- Route Method
- RowDifferences Method
- RTD Method
- Run Method
- RunAutoMacros Method
-
S
- Save Method
- SaveAs Method
- SaveAsODC Method
- SaveAsXMLData Method
- SaveCopyAs Method
- SaveWorkspace Method
- ScaleHeight Method
- ScaleWidth Method
- Scenarios Method
- ScrollIntoView Method
- ScrollWorkbookTabs Method
- Select Method
- SelectAll Method
- SendFaxOverInternet Method
- SendForReview Method
- SendKeys Method
- SendMail Method
- SendMailer Method
- SendToBack Method
- SeriesCollection Method
- ServerStart Method
- ServerTerminate Method
- SetBackgroundPicture Method
- SetDefaultChart Method
- SetEditingType Method
- SetExtrusionDirection Method
- SetLinkOnData Method
- SetParam Method
- SetPasswordEncryptionOptions Method
- SetPhonetic Method
- SetPosition Method
- SetSegmentType Method
- SetShapesDefaultProperties Method
- SetSourceData Method
- SetThreeDFormat Method
- SetValue Method
- Show Method
- ShowAllData Method
- ShowDataForm Method
- ShowDependents Method
- ShowErrors Method
- ShowLevels Method
- ShowPages Method
- ShowPrecedents Method
- SmallScroll Method
- Solid Method
- Sort Method
- SortSpecial Method
- Speak Method
- SpecialCells Method
- SubscribeTo Method
- Subtotal Method
- SwapNode Method
- T
- U
- V
- W
- X
- Z
-
A
-
Properties
-
A
- Accent Property
- AcceptLabelsInFormulas Property
- Active Property
- ActiveCell Property
- ActiveChart Property
- ActivePane Property
- ActivePrinter Property
- ActiveSheet Property
- ActiveWindow Property
- ActiveWorkbook Property
- ActiveXControl Property
- AddIndent Property
- AddIns Property
- Address Property
- AddressLocal Property
- AdjustColumnWidth Property
- Adjustments Property
- ADOConnection Property
- AlertBeforeOverwriting Property
- AlertStyle Property
- Alignment Property
- AllowDeletingColumns Property
- AllowDeletingRows Property
- AllowEdit Property
- AllowEditRanges Property
- AllowFillIn Property
- AllowFiltering Property
- AllowFormattingCells Property
- AllowFormattingColumns Property
- AllowFormattingRows Property
- AllowInsertingColumns Property
- AllowInsertingHyperlinks Property
- AllowInsertingRows Property
- AllowPNG Property
- AllowSorting Property
- AllowUsingPivotTables Property
- AlternativeText Property
- AltStartupPath Property
- AlwaysSaveInDefaultEncoding Property
- Angle Property
- AnswerWizard Property
- AppendOnImport Property
- Application Property
- ApplyPictToEnd Property
- ApplyPictToFront Property
- ApplyPictToSides Property
- ArabicModes Property
- ArbitraryXMLSupportAvailable Property
- Area3DGroup Property
- Areas Property
- AskToUpdateLinks Property
- Assistant Property
- Author Property
- AutoAttach Property
- AutoCorrect Property
- AutoExpandListRange Property
- AutoFilter Property
- AutoFilterMode Property
- AutoFormat Property
- AutoFormatAsYouTypeReplaceHyperlinks Property
- AutoLayout Property
- AutoLength Property
- AutoLoad Property
- AutoMargins Property
- AutomaticStyles Property
- AutomationSecurity Property
- AutoPercentEntry Property
- AutoRecover Property
- AutoRepublish Property
- AutoScaleFont Property
- AutoScaling Property
- AutoShapeType Property
- AutoShowCount Property
- AutoShowField Property
- AutoShowRange Property
- AutoShowType Property
- AutoSize Property
- AutoSortField Property
- AutoSortOrder Property
- AutoText Property
- AutoUpdate Property
- AutoUpdateFrequency Property
- AutoUpdateSaveChanges Property
- AxisBetweenCategories Property
- AxisGroup Property
- AxisTitle Property
-
B
- BackColor Property
- Background Property
- BackgroundChecking Property
- BackgroundQuery Property
- Backward Property
- Bar3DGroup Property
- BarShape Property
- BaseField Property
- BaseItem Property
- BaseUnit Property
- BaseUnitIsAuto Property
- BCCRecipients Property
- BeginArrowheadLength Property
- BeginArrowheadStyle Property
- BeginArrowheadWidth Property
- BeginConnected Property
- BeginConnectedShape Property
- BeginConnectionSite Property
- BlackAndWhite Property
- BlackWhiteMode Property
- Bold Property
- Border Property
- Borders Property
- BottomMargin Property
- BottomRightCell Property
- Brightness Property
- BubbleScale Property
- BubbleSizes Property
- Build Property
- BuiltIn Property
- BuiltinDocumentProperties Property
-
C
- CacheIndex Property
- CalculateBeforeSave Property
- CalculatedMembers Property
- Calculation Property
- CalculationInterruptKey Property
- CalculationState Property
- CalculationVersion Property
- Caller Property
- Callout Property
- CanPlaySounds Property
- CanRecordSounds Property
- CapitalizeNamesOfDays Property
- Caption Property
- Category Property
- CategoryLocal Property
- CategoryNames Property
- CategoryType Property
- CCRecipients Property
- CellDragAndDrop Property
- Cells Property
- CenterFooter Property
- CenterFooterPicture Property
- CenterHeader Property
- CenterHeaderPicture Property
- CenterHorizontally Property
- CenterVertically Property
- ChangeHistoryDuration Property
- ChangingCells Property
- Characters Property
- CharacterType Property
- Chart Property
- ChartArea Property
- Charts Property
- ChartSize Property
- ChartTitle Property
- ChartType Property
- CheckboxState Property
- CheckIfOfficeIsHTMLEditor Property
- Child Property
- ChildField Property
- ChildItems Property
- Children Property
- Choices Property
- CircularReference Property
- ClipboardFormats Property
- CLSID Property
- CodeName Property
- Color Property
- ColorIndex Property
- Colors Property
- ColorType Property
- Column Property
- Column3DGroup Property
- ColumnFields Property
- ColumnGrand Property
- ColumnItems Property
- ColumnRange Property
- Columns Property
- ColumnWidth Property
- COMAddIns Property
- CommandBars Property
- CommandText Property
- CommandType Property
- CommandUnderlines Property
- Comment Property
- Comments Property
- ConflictResolution Property
- Connection Property
- ConnectionSiteCount Property
- Connector Property
- ConnectorFormat Property
- ConsolidationFunction Property
- ConsolidationOptions Property
- ConsolidationSources Property
- ConstrainNumeric Property
- Container Property
- Contrast Property
- ControlCharacters Property
- ControlFormat Property
- CopyObjectsWithCells Property
- Corners Property
- CorrectCapsLock Property
- CorrectSentenceCap Property
- Count Property
- CreateBackup Property
- Creator Property
- Criteria1 Property
- Criteria2 Property
- CropBottom Property
- CropLeft Property
- CropRight Property
- CropTop Property
- Crosses Property
- CrossesAt Property
- CubeField Property
- CubeFields Property
- CubeFieldType Property
- CurrentArray Property
- CurrentPage Property
- CurrentPageList Property
- CurrentPageName Property
- CurrentRegion Property
- Cursor Property
- CursorMovement Property
- CustomDocumentProperties Property
- CustomListCount Property
- CustomProperties Property
- CustomSubtotalFunction Property
- CustomViews Property
- CutCopyMode Property
-
D
- DashStyle Property
- DatabaseSort Property
- DataBinding Property
- DataBodyRange Property
- DataEntryMode Property
- DataField Property
- DataFields Property
- DataLabel Property
- DataLabelRange Property
- DataPivotField Property
- DataRange Property
- DataTable Property
- DataType Property
- Date1904 Property
- DDEAppReturnCode Property
- DecimalPlaces Property
- DecimalSeparator Property
- DefaultFilePath Property
- DefaultSaveFormat Property
- DefaultSheetDirection Property
- DefaultValue Property
- DefaultWebOptions Property
- Delivery Property
- Dependents Property
- Depth Property
- DepthPercent Property
- Destination Property
- Diagram Property
- DiagramNode Property
- Dialogs Property
- DictLang Property
- DirectDependents Property
- Direction Property
- DirectPrecedents Property
- DisplayAlerts Property
- DisplayAutoCorrectOptions Property
- DisplayBlanksAs Property
- DisplayClipboardWindow Property
- DisplayCommentIndicator Property
- DisplayDocumentActionTaskPane Property
- DisplayDrawingObjects Property
- DisplayEmptyColumn Property
- DisplayEmptyRow Property
- DisplayEquation Property
- DisplayErrorString Property
- DisplayExcel4Menus Property
- DisplayFormulaBar Property
- DisplayFormulas Property
- DisplayFullScreen Property
- DisplayFunctionToolTips Property
- DisplayGridlines Property
- DisplayHeadings Property
- DisplayHorizontalScrollBar Property
- DisplayImmediateItems Property
- DisplayInkComments Property
- DisplayInsertOptions Property
- DisplayNoteIndicator Property
- DisplayNullString Property
- DisplayOutline Property
- DisplayPageBreaks Property
- DisplayPasteOptions Property
- DisplayRecentFiles Property
- DisplayRightToLeft Property
- DisplayRSquared Property
- DisplayScrollBars Property
- DisplaySmartTags Property
- DisplayStatusBar Property
- DisplayUnit Property
- DisplayUnitCustom Property
- DisplayUnitLabel Property
- DisplayVerticalScrollBar Property
- DisplayWorkbookTabs Property
- DisplayZeros Property
- DivID Property
- DocumentLibraryVersions Property
- DoughnutHoleSize Property
- DownBars Property
- DownloadComponents Property
- DownloadURL Property
- Draft Property
- DragToColumn Property
- DragToData Property
- DragToHide Property
- DragToPage Property
- DragToRow Property
- Drilled Property
- DrilledDown Property
- Drop Property
- DropDownLines Property
- DropLines Property
- DropType Property
-
E
- EditDirectlyInCell Property
- EditingType Property
- EditWebPage Property
- Elevation Property
- EmailSubject Property
- EmbedSmartTags Property
- EmptyCellReferences Property
- EnableAnimations Property
- EnableAutoComplete Property
- EnableAutoFilter Property
- EnableAutoRecover Property
- EnableCalculation Property
- EnableCancelKey Property
- Enabled Property
- EnableDataValueEditing Property
- EnableDrilldown Property
- EnableEditing Property
- EnableEvents Property
- EnableFieldDialog Property
- EnableFieldList Property
- EnableItemSelection Property
- EnableMultiplePageItems Property
- EnableOutlining Property
- EnablePivotTable Property
- EnableRefresh Property
- EnableResize Property
- EnableSelection Property
- EnableSound Property
- EnableWizard Property
- Enclosures Property
- Encoding Property
- End Property
- EndArrowheadLength Property
- EndArrowheadStyle Property
- EndArrowheadWidth Property
- EndConnected Property
- EndConnectedShape Property
- EndConnectionSite Property
- EndStyle Property
- EntireColumn Property
- EntireRow Property
- EnvelopeVisible Property
- ErrorBars Property
- ErrorCheckingOptions Property
- ErrorMessage Property
- Errors Property
- ErrorString Property
- ErrorTitle Property
- EvaluateToError Property
- Excel4IntlMacroSheets Property
- Excel4MacroSheets Property
- ExpandHelp Property
- Explosion Property
- ExtendList Property
- Extent Property
- ExtrusionColor Property
- ExtrusionColorType Property
-
F
- FeatureInstall Property
- FetchedRowOverflow Property
- FieldNames Property
- FileConverters Property
- FileDialog Property
- FileFind Property
- FileFormat Property
- Filename Property
- FileSearch Property
- Fill Property
- FillAdjacentFormulas Property
- FilterMode Property
- Filters Property
- FindFormat Property
- FirstChild Property
- FirstPageNumber Property
- FirstSliceAngle Property
- FitToPagesTall Property
- FitToPagesWide Property
- FixedDecimal Property
- FixedDecimalPlaces Property
- Floor Property
- FolderSuffix Property
- Font Property
- FontBold Property
- FontItalic Property
- FontName Property
- Fonts Property
- FontSize Property
- FontStyle Property
- FooterMargin Property
- ForeColor Property
- FormatConditions Property
- FormControlType Property
- Formula Property
- Formula1 Property
- Formula2 Property
- FormulaArray Property
- FormulaHidden Property
- FormulaLabel Property
- FormulaLocal Property
- FormulaR1C1 Property
- FormulaR1C1Local Property
- Forward Property
- FreezePanes Property
- FullName Property
- FullNameURLEncoded Property
- Function Property
-
G
- Gap Property
- GapDepth Property
- GapWidth Property
- GenerateGetPivotData Property
- GermanPostReform Property
- GradientColorType Property
- GradientDegree Property
- GradientStyle Property
- GradientVariant Property
- GrandTotalName Property
- GridlineColor Property
- GridlineColorIndex Property
- GroupItems Property
- GroupLevel Property
-
H
- Has3DEffect Property
- Has3DShading Property
- HasArray Property
- HasAutoFormat Property
- HasAxis Property
- HasBorderHorizontal Property
- HasBorderOutline Property
- HasBorderVertical Property
- HasDataLabel Property
- HasDataLabels Property
- HasDataTable Property
- HasDiagram Property
- HasDiagramNode Property
- HasDisplayUnitLabel Property
- HasDropLines Property
- HasErrorBars Property
- HasFormula Property
- HasHiLoLines Property
- HasLeaderLines Property
- HasLegend Property
- HasMajorGridlines Property
- HasMemberProperties Property
- HasMinorGridlines Property
- HasPassword Property
- HasPivotFields Property
- HasRadarAxisLabels Property
- HasRoutingSlip Property
- HasSeriesLines Property
- HasTitle Property
- HasUpDownBars Property
- HeaderMargin Property
- HeaderRowRange Property
- HeartbeatInterval Property
- HebrewModes Property
- Height Property
- HeightPercent Property
- Hidden Property
- HiddenFields Property
- HiddenItems Property
- HiddenItemsList Property
- HighlightChangesOnScreen Property
- HiLoLines Property
- Hinstance Property
- HorizontalAlignment Property
- HorizontalFlip Property
- HPageBreaks Property
- HTMLProject Property
- HtmlType Property
- Hwnd Property
- Hyperlink Property
- Hyperlinks Property
-
I
- ID Property
- Ignore Property
- IgnoreBlank Property
- IgnoreCaps Property
- IgnoreFileNames Property
- IgnoreMixedDigits Property
- IgnoreRemoteRequests Property
- IMEMode Property
- InactiveListBorderVisible Property
- InCellDropdown Property
- IncludeAlignment Property
- IncludeBorder Property
- IncludeFont Property
- IncludeNumber Property
- IncludePatterns Property
- IncludeProtection Property
- InconsistentFormula Property
- IndentLevel Property
- Index Property
- IndicatorColorIndex Property
- InnerDetail Property
- InputMessage Property
- InputTitle Property
- InsertRowRange Property
- InsideHeight Property
- InsideLeft Property
- InsideTop Property
- InsideWidth Property
- Installed Property
- Interactive Property
- Intercept Property
- InterceptIsAuto Property
- Interior Property
- International Property
- InvalidData Property
- InvertIfNegative Property
- IsAddin Property
- IsCalculated Property
- IsConnected Property
- IsExportable Property
- IsInplace Property
- IsMemberProperty Property
- IsPercent Property
- IsValid Property
- Italic Property
- Item Property
- Iteration Property
- K
-
L
- LabelRange Property
- LanguageSettings Property
- LargeChange Property
- LastChild Property
- Layout Property
- LayoutBlankLine Property
- LayoutForm Property
- LayoutPageBreak Property
- LayoutSubtotalLocation Property
- lcid Property
- LeaderLines Property
- Left Property
- LeftFooter Property
- LeftFooterPicture Property
- LeftHeader Property
- LeftHeaderPicture Property
- LeftMargin Property
- Legend Property
- LegendKey Property
- Length Property
- LibraryPath Property
- Line Property
- Line3DGroup Property
- LineStyle Property
- LinkedCell Property
- LinkFormat Property
- ListChangesOnNewSheet Property
- ListColumns Property
- ListCount Property
- ListDataFormat Property
- ListDataValidation Property
- ListFillRange Property
- ListHeaderRows Property
- ListIndex Property
- ListObject Property
- ListObjects Property
- ListRows Property
- ListSelection Property
- LoadPictures Property
- LocalConnection Property
- Location Property
- LocationInTable Property
- LocationOfComponents Property
- LockAspectRatio Property
- Locked Property
- LockedText Property
-
M
- MacroType Property
- MailEnvelope Property
- Mailer Property
- MailSession Property
- MailSystem Property
- MaintainConnection Property
- MajorGridlines Property
- MajorTickMark Property
- MajorUnit Property
- MajorUnitIsAuto Property
- MajorUnitScale Property
- ManualUpdate Property
- Map Property
- MapPaperSize Property
- MarginBottom Property
- MarginLeft Property
- MarginRight Property
- MarginTop Property
- MarkerBackgroundColor Property
- MarkerBackgroundColorIndex Property
- MarkerForegroundColor Property
- MarkerForegroundColorIndex Property
- MarkerSize Property
- MarkerStyle Property
- MathCoprocessorAvailable Property
- Max Property
- MaxChange Property
- MaxCharacters Property
- Maximum Property
- MaximumScale Property
- MaximumScaleIsAuto Property
- MaxIterations Property
- MaxNumber Property
- MDX Property
- MemoryFree Property
- MemoryUsed Property
- MergeArea Property
- MergeCells Property
- MergeLabels Property
- Message Property
- Min Property
- MinimumScale Property
- MinimumScaleIsAuto Property
- MinNumber Property
- MinorGridlines Property
- MinorTickMark Property
- MinorUnit Property
- MinorUnitIsAuto Property
- MinorUnitScale Property
- MissingItemsLimit Property
- MouseAvailable Property
- MoveAfterReturn Property
- MoveAfterReturnDirection Property
- MultiSelect Property
- MultiUserEditing Property
-
N
- Name Property
- NameIsAuto Property
- NameLocal Property
- Names Property
- Namespace Property
- Native Property
- NetworkTemplatesPath Property
- NewWorkbook Property
- Next Property
- Nodes Property
- NormalizedHeight Property
- NullString Property
- Number Property
- NumberAsText Property
- NumberFormat Property
- NumberFormatLinked Property
- NumberFormatLocal Property
-
O
- Object Property
- Obscured Property
- ODBCErrors Property
- ODBCTimeout Property
- Offset Property
- OffsetX Property
- OffsetY Property
- OLAP Property
- OLEDBErrors Property
- OLEFormat Property
- OLEType Property
- OmittedCells Property
- On Property
- OnAction Property
- OnWindow Property
- OperatingSystem Property
- Operator Property
- OptimizeCache Property
- Order Property
- OrganizationName Property
- OrganizeInFolder Property
- Orientation Property
- Outline Property
- OutlineFont Property
- OutlineLevel Property
- Overlap Property
-
P
- PageBreak Property
- PageFieldOrder Property
- PageFields Property
- PageFieldStyle Property
- PageFieldWrapCount Property
- PageRange Property
- PageRangeCells Property
- PageSetup Property
- Panes Property
- PaperSize Property
- Parameters Property
- Parent Property
- ParentField Property
- ParentGroup Property
- ParentItem Property
- ParentItems Property
- ParentShowDetail Property
- Password Property
- PasswordEncryptionAlgorithm Property
- PasswordEncryptionFileProperties Property
- PasswordEncryptionKeyLength Property
- PasswordEncryptionProvider Property
- Path Property
- PathSeparator Property
- Pattern Property
- PatternColor Property
- PatternColorIndex Property
- Period Property
- Permission Property
- PersonalViewListSettings Property
- PersonalViewPrintSettings Property
- Perspective Property
- Phonetic Property
- PhoneticCharacters Property
- Phonetics Property
- PictureFormat Property
- PictureType Property
- PictureUnit Property
- Pie3DGroup Property
- PivotCell Property
- PivotCellType Property
- PivotField Property
- PivotFields Property
- PivotFormulas Property
- PivotItem Property
- PivotLayout Property
- PivotSelection Property
- PivotSelectionStandard Property
- PivotTable Property
- PivotTableSelection Property
- PixelsPerInch Property
- Placement Property
- PlotArea Property
- PlotBy Property
- PlotOrder Property
- PlotVisibleOnly Property
- Points Property
- Position Property
- PostText Property
- Precedents Property
- PrecisionAsDisplayed Property
- Prefix Property
- PrefixCharacter Property
- PresentInPane Property
- PreserveColumnFilter Property
- PreserveColumnInfo Property
- PreserveFormatting Property
- PreserveNumberFormatting Property
- PresetExtrusionDirection Property
- PresetGradientType Property
- PresetLightingDirection Property
- PresetLightingSoftness Property
- PresetMaterial Property
- PresetShape Property
- PresetTextEffect Property
- PresetTexture Property
- PresetThreeDFormat Property
- Previous Property
- PreviousSelections Property
- PrintArea Property
- PrintComments Property
- PrintErrors Property
- PrintGridlines Property
- PrintHeadings Property
- PrintNotes Property
- PrintObject Property
- PrintQuality Property
- PrintSettings Property
- PrintTitleColumns Property
- PrintTitleRows Property
- PrintTitles Property
- ProductCode Property
- progID Property
- PromptForSummaryInfo Property
- PromptString Property
- Properties Property
- PropertyOrder Property
- PropertyParentField Property
- ProtectChartObject Property
- ProtectContents Property
- ProtectData Property
- ProtectDrawingObjects Property
- ProtectFormatting Property
- ProtectGoalSeek Property
- Protection Property
- ProtectionMode Property
- ProtectScenarios Property
- ProtectSelection Property
- ProtectStructure Property
- ProtectWindows Property
- PublishObjects Property
- Q
-
R
- RadarAxisLabels Property
- RadioGroupSelection Property
- Range Property
- RangeSelection Property
- ReadingOrder Property
- ReadOnly Property
- ReadOnlyRecommended Property
- Ready Property
- Received Property
- RecentFiles Property
- Recipients Property
- Recognize Property
- RecordCount Property
- RecordRelative Property
- Recordset Property
- ReferenceStyle Property
- RefersTo Property
- RefersToLocal Property
- RefersToR1C1 Property
- RefersToR1C1Local Property
- RefersToRange Property
- RefreshDate Property
- Refreshing Property
- RefreshName Property
- RefreshOnChange Property
- RefreshOnFileOpen Property
- RefreshPeriod Property
- RefreshStyle Property
- RegisteredFunctions Property
- RelyOnCSS Property
- RelyOnVML Property
- RemovePersonalInformation Property
- Repeating Property
- RepeatItemsOnEachPrintedPage Property
- ReplaceFormat Property
- ReplacementList Property
- ReplaceText Property
- Required Property
- Resize Property
- ResultRange Property
- ReturnWhenDone Property
- Reverse Property
- ReversePlotOrder Property
- RevisionNumber Property
- RGB Property
- RightAngleAxes Property
- RightFooter Property
- RightFooterPicture Property
- RightHeader Property
- RightHeaderPicture Property
- RightMargin Property
- RobustConnect Property
- RollZoom Property
- Root Property
- RootElementName Property
- RootElementNamespace Property
- RotatedChars Property
- Rotation Property
- RotationX Property
- RotationY Property
- RoundedCorners Property
- Routed Property
- RoutingSlip Property
- Row Property
- RowColSettings Property
- RowFields Property
- RowGrand Property
- RowHeight Property
- RowItems Property
- RowNumbers Property
- RowRange Property
- Rows Property
- RTD Property
-
S
- Saved Property
- SaveData Property
- SaveDataSourceDefinition Property
- SaveHiddenData Property
- SaveLinkValues Property
- SaveNewWebPagesAsWebArchives Property
- SavePassword Property
- ScaleType Property
- Schemas Property
- SchemeColor Property
- ScreenSize Property
- ScreenTip Property
- ScreenUpdating Property
- Script Property
- Scripts Property
- ScrollArea Property
- ScrollColumn Property
- ScrollRow Property
- SecondaryPlot Property
- SecondPlotSize Property
- SegmentType Property
- SelectedSheets Property
- Selection Property
- SelectionMode Property
- SendDateTime Property
- Sender Property
- Separator Property
- SeriesLines Property
- ServerBased Property
- Shadow Property
- Shape Property
- ShapeRange Property
- Shapes Property
- SharedWorkspace Property
- SharePointFormula Property
- SharePointURL Property
- Sheet Property
- Sheets Property
- SheetsInNewWorkbook Property
- ShortcutKey Property
- ShowAllItems Property
- ShowAutoFilter Property
- ShowBubbleSize Property
- ShowCategoryName Property
- ShowCellBackgroundFromOLAP Property
- ShowChartTipNames Property
- ShowChartTipValues Property
- ShowConflictHistory Property
- ShowDetail Property
- ShowError Property
- ShowImportExportValidationErrors Property
- ShowInFieldList Property
- ShowInput Property
- ShowLegendKey Property
- ShowNegativeBubbles Property
- ShowPageMultipleItemLabel Property
- ShowPercentage Property
- ShowPivotTableFieldList Property
- ShowSeriesName Property
- ShowStartupDialog Property
- ShowToolTips Property
- ShowTotals Property
- ShowValue Property
- ShowWindow Property
- ShowWindowsInTaskbar Property
- ShrinkToFit Property
- Size Property
- SizeRepresents Property
- SizeWithWindow Property
- SmallChange Property
- SmallGrid Property
- SmartDocument Property
- SmartTagActions Property
- SmartTagOptions Property
- SmartTagRecognizers Property
- SmartTags Property
- Smooth Property
- SolveOrder Property
- SoundNote Property
- Source Property
- SourceConnectionFile Property
- SourceData Property
- SourceDataFile Property
- SourceName Property
- SourceNameStandard Property
- SourceRange Property
- SourceType Property
- SourceUrl Property
- SpeakCellOnEnter Property
- Speech Property
- SpellingOptions Property
- Split Property
- SplitColumn Property
- SplitHorizontal Property
- SplitRow Property
- SplitType Property
- SplitValue Property
- SplitVertical Property
- SqlState Property
- Stage Property
- StandardFont Property
- StandardFontSize Property
- StandardFormula Property
- StandardHeight Property
- StandardWidth Property
- Start Property
- StartupPath Property
- Status Property
- StatusBar Property
- Strikethrough Property
- Style Property
- Styles Property
- SubAddress Property
- Subject Property
- Subscript Property
- SubtotalHiddenPageItems Property
- SubtotalName Property
- Subtotals Property
- SuggestMainOnly Property
- Summary Property
- SummaryColumn Property
- SummaryRow Property
- Superscript Property
- SurfaceGroup Property
- Sync Property
- SyncScrollingSideBySide Property
-
T
- Tab Property
- TableRange1 Property
- TableRange2 Property
- TableStyle Property
- TabRatio Property
- Tag Property
- TargetBrowser Property
- TemplateRemoveExtData Property
- TemplatesPath Property
- Text Property
- TextboxText Property
- TextDate Property
- TextEffect 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
- TextFrame Property
- TextShape Property
- TextToDisplay Property
- TextureName Property
- TextureType Property
- ThisCell Property
- ThisWorkbook Property
- ThousandsSeparator Property
- ThreeD Property
- ThrottleInterval Property
- TickLabelPosition Property
- TickLabels Property
- TickLabelSpacing Property
- TickMarkSpacing Property
- Time Property
- TintAndShade Property
- Title Property
- Top Property
- TopLeftCell Property
- TopMargin Property
- ToRecipients Property
- TotalLevels Property
- TotalsAnnotation Property
- TotalsCalculation Property
- TotalsRowRange Property
- Tracking Property
- TrackStatus Property
- TransitionExpEval Property
- TransitionFormEntry Property
- TransitionMenuKey Property
- TransitionMenuKeyAction Property
- TransitionNavigKeys Property
- Transparency Property
- TransparencyColor Property
- TransparentBackground Property
- TreeviewControl Property
- TwoInitialCapitals Property
- Type Property
-
U
- Underline Property
- UnlockedFormulaCells Property
- UpBars Property
- UpdateLinks Property
- UpdateLinksOnSave Property
- UpdateRemoteReferences Property
- Uri Property
- UsableHeight Property
- UsableWidth Property
- UsedObjects Property
- UsedRange Property
- UseLocalConnection Property
- UseLongFileNames Property
- UserControl Property
- UserDict Property
- UserLibraryPath Property
- UserName Property
- Users Property
- UserStatus Property
- UseStandardHeight Property
- UseStandardWidth Property
- UseSystemSeparators Property
-
V
- VacatedStyle Property
- Validation Property
- Value Property
- Value2 Property
- Values Property
- VaryByCategories Property
- VBASigned Property
- VBE Property
- VBProject Property
- Version Property
- VerticalAlignment Property
- VerticalFlip Property
- Vertices Property
- View Property
- ViewCalculatedMembers Property
- Visible Property
- VisibleFields Property
- VisibleItems Property
- VisibleRange Property
- VisualTotals Property
- VPageBreaks Property
-
W
- Walls Property
- WallsAndGridlines2D Property
- Watches Property
- WebConsecutiveDelimitersAsOne Property
- WebDisableDateRecognition Property
- WebDisableRedirections Property
- WebFormatting Property
- WebOptions Property
- WebPreFormattedTextToColumns Property
- WebSelectionType Property
- WebSingleBlockTextImport Property
- WebTables Property
- Weight Property
- WhichAddress Property
- Width Property
- WindowNumber Property
- Windows Property
- WindowsForPens Property
- WindowState Property
- Workbooks Property
- Worksheet Property
- WorksheetFunction Property
- Worksheets Property
- WrapText Property
- WritePassword Property
- WriteReserved Property
- WriteReservedBy Property
- X
- Z
-
A
-
Events
- A
- B
- C
- D
- F
- G
- L
- M
- N
- O
- P
- R
- S
-
W
- WindowActivate Event
- WindowDeactivate Event
- WindowResize Event
- WorkbookActivate Event
- WorkbookAddinInstall Event
- WorkbookAddinUninstall Event
- WorkbookAfterXmlExport Event
- WorkbookAfterXmlImport Event
- WorkbookBeforeClose Event
- WorkbookBeforePrint Event
- WorkbookBeforeSave Event
- WorkbookBeforeXmlExport Event
- WorkbookBeforeXmlImport Event
- WorkbookDeactivate Event
- WorkbookNewSheet Event
- WorkbookOpen Event
- WorkbookPivotTableCloseConnection Event
- WorkbookPivotTableOpenConnection Event
- WorkbookSync Event
- Enumerations