Excel Objects

AddIn (1995) Represents a single add-in, either installed or not installed. The AddIn object is a member of the AddIns collection. The AddIns collection contains a list of all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).

Application
Author
CLSID
Comments
Creator
FullName
Installed [= setting]
Keywords
Name
Parent
Path
progID
Subject
Title

AddIns (1995) A collection of AddIn objects that represents all the add-ins available to Microsoft Excel, regardless of whether theyre installed. This list corresponds to the list of add-ins displayed in the Add-Ins dialog box (Tools menu).

Add(Filename, [CopyFile])
Application
Count
Creator
GetEnumerator()
Item
Parent

Adjustments (1997) Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector. Each adjustment value represents one way an adjustment handle can be adjusted. Because some adjustment handles can be adjusted in two ways  for instance, some handles can be adjusted both horizontally and vertically  a shape can have more adjustment values than it has adjustment handles. A shape can have up to eight adjustments.

Application
Count
Creator
Item [= setting]
Parent

AllowEditRange (2002) Represents the cells that can be edited on a protected worksheet.

ChangePassword(Password)
Delete()
Range [= setting]
Title [= setting]
Unprotect([Password])
Users

AllowEditRanges (2002) A collection of all the AllowEditRanges objects that represent the cells that can be edited on a protected worksheet.

Add(Title, Range, [Password])
Count
GetEnumerator()
Item

AppEvents (1997) Hidden or unsupported element.

NewWorkbook(Wb)
SheetActivate(Sh)
SheetBeforeDoubleClick(Sh, Target, Cancel)
SheetBeforeRightClick(Sh, Target, Cancel)
SheetCalculate(Sh)
SheetChange(Sh, Target)
SheetDeactivate(Sh)
SheetFollowHyperlink(Sh, Target)
SheetPivotTableUpdate(Sh, Target)
SheetSelectionChange(Sh, Target)
WindowActivate(Wb, Wn)
WindowDeactivate(Wb, Wn)
WindowResize(Wb, Wn)
WorkbookActivate(Wb)
WorkbookAddinInstall(Wb)
WorkbookAddinUninstall(Wb)
WorkbookAfterXmlExport(Wb, Map, Url, Result)
WorkbookAfterXmlImport(Wb, Map, IsRefresh, Result)
WorkbookBeforeClose(Wb, Cancel)
WorkbookBeforePrint(Wb, Cancel)
WorkbookBeforeSave(Wb, SaveAsUI, Cancel)
WorkbookBeforeXmlExport(Wb, Map, Url, Cancel)
WorkbookBeforeXmlImport(Wb, Map, Url, IsRefresh, Cancel)
WorkbookDeactivate(Wb)
WorkbookNewSheet(Wb, Sh)
WorkbookOpen(Wb)
WorkbookPivotTableCloseConnection(Wb, Target)
WorkbookPivotTableOpenConnection(Wb, Target)
WorkbookSync(Wb, SyncEventType)

Application (1995) Represents the entire Microsoft Excel application.

ActivateMicrosoftApp(Index)
ActiveCell
ActiveChart
ActiveDialog
ActiveMenuBar
ActivePrinter [= setting]
ActiveSheet
ActiveWindow
ActiveWorkbook
AddChartAutoFormat(Chart, Name, [Description])
AddCustomList(ListArray, [ByRow])
AddIns
AlertBeforeOverwriting [= setting]
AltStartupPath [= setting]
AnswerWizard
AppEvents_Event_NewWorkbook
Application
ArbitraryXMLSupportAvailable
AskToUpdateLinks [= setting]
Assistant
AutoCorrect
AutoFormatAsYouTypeReplaceHyperlinks [= setting]
AutomationSecurity [= setting]
AutoPercentEntry [= setting]
AutoRecover
Build
Calculate()
CalculateBeforeSave [= setting]
CalculateFull()
CalculateFullRebuild()
Calculation [= setting]
CalculationInterruptKey [= setting]
CalculationState
CalculationVersion
Caller
CanPlaySounds
CanRecordSounds
Caption [= setting]
CellDragAndDrop [= setting]
Cells
CentimetersToPoints(Centimeters)
Charts
CheckAbort([KeepAbort])
CheckSpelling(Word, [CustomDictionary], [IgnoreUppercase])
ClipboardFormats
ColorButtons [= setting]
Columns
COMAddIns
CommandBars
CommandUnderlines [= setting]
ConstrainNumeric [= setting]
ControlCharacters [= setting]
ConvertFormula(Formula, FromReferenceStyle, [ToReferenceStyle], [ToAbsolute], [RelativeTo])
CopyObjectsWithCells [= setting]
CreateObjRef(requestedType)
Creator
Cursor [= setting]
CursorMovement [= setting]
CustomListCount
CutCopyMode [= setting]
DataEntryMode [= setting]
DDEAppReturnCode
DDEExecute(Channel, String)
DDEInitiate(App, Topic)
DDEPoke(Channel, Item, Data)
DDERequest(Channel, Item)
DDETerminate(Channel)
DecimalSeparator [= setting]
DefaultFilePath [= setting]
DefaultSaveFormat [= setting]
DefaultSheetDirection [= setting]
DefaultWebOptions
DeleteChartAutoFormat(Name)
DeleteCustomList(ListNum)
Dialogs
DialogSheets
DisplayAlerts [= setting]
DisplayClipboardWindow [= setting]
DisplayCommentIndicator [= setting]
DisplayDocumentActionTaskPane [= setting]
DisplayExcel4Menus [= setting]
DisplayFormulaBar [= setting]
DisplayFullScreen [= setting]
DisplayFunctionToolTips [= setting]
DisplayInfoWindow [= setting]
DisplayInsertOptions [= setting]
DisplayNoteIndicator [= setting]
DisplayPasteOptions [= setting]
DisplayRecentFiles [= setting]
DisplayScrollBars [= setting]
DisplayStatusBar [= setting]
DisplayXMLSourcePane([XmlMap])
DoubleClick()
Dummy1([Arg1], [Arg2], [Arg3], [Arg4])
Dummy10([arg])
Dummy101
Dummy11()
Dummy12(p1, p2)
Dummy13(Arg1, [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Dummy14()
Dummy2([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8])
Dummy3()
Dummy4([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15])
Dummy5([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13])
Dummy6()
Dummy7()
Dummy8([Arg1])
Dummy9()
EditDirectlyInCell [= setting]
EnableAnimations [= setting]
EnableAutoComplete [= setting]
EnableCancelKey [= setting]
EnableEvents [= setting]
EnableSound [= setting]
EnableTipWizard [= setting]
Equals(obj)
ErrorCheckingOptions
Evaluate(Name)
Excel4IntlMacroSheets
Excel4MacroSheets
ExecuteExcel4Macro(String)
ExtendList [= setting]
FeatureInstall [= setting]
FileConverters
FileDialog
FileFind
FileSearch
FindFile()
FindFormat [= setting]
FixedDecimal [= setting]
FixedDecimalPlaces [= setting]
GenerateGetPivotData [= setting]
GetCustomListContents(ListNum)
GetCustomListNum(ListArray)
GetHashCode()
GetLifetimeService()
GetOpenFilename([FileFilter], [FilterIndex], [Title], [ButtonText], [MultiSelect])
GetPhonetic([Text])
GetSaveAsFilename([InitialFilename], [FileFilter], [FilterIndex], [Title], [ButtonText])
GetType()
Goto([Reference], [Scroll])
Height [= setting]
Help([HelpFile], [HelpContextID])
Hinstance
Hwnd
IgnoreRemoteRequests [= setting]
InchesToPoints(Inches)
InitializeLifetimeService()
InputBox(Prompt, [Title], [Default], [Left], [Top], [HelpFile], [HelpContextID], [Type])
Interactive [= setting]
International
Intersect(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Iteration [= setting]
LanguageSettings
LargeButtons [= setting]
Left [= setting]
LibraryPath
MacroOptions([Macro], [Description], [HasMenu], [MenuText], [HasShortcutKey], [ShortcutKey], [Category], [StatusBar], [HelpContextID], [HelpFile])
MailLogoff()
MailLogon([Name], [Password], [DownloadNewMail])
MailSession
MailSystem
MapPaperSize [= setting]
MathCoprocessorAvailable
MaxChange [= setting]
MaxIterations [= setting]
MemoryFree
MemoryTotal
MemoryUsed
MenuBars
Modules
MouseAvailable
MoveAfterReturn [= setting]
MoveAfterReturnDirection [= setting]
Name
Names
NetworkTemplatesPath
NewWorkbook
NextLetter()
ODBCErrors
ODBCTimeout [= setting]
OLEDBErrors
OnCalculate [= setting]
OnData [= setting]
OnDoubleClick [= setting]
OnEntry [= setting]
OnKey(Key, [Procedure])
OnRepeat(Text, Procedure)
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
OnTime(EarliestTime, Procedure, [LatestTime], [Schedule])
OnUndo(Text, Procedure)
OnWindow [= setting]
OperatingSystem
OrganizationName
Parent
Path
PathSeparator
PivotTableSelection [= setting]
PreviousSelections
ProductCode
PromptForSummaryInfo [= setting]
Quit()
Range
Ready
RecentFiles
RecordMacro([BasicCode], [XlmCode])
RecordRelative
ReferenceStyle [= setting]
RegisteredFunctions
RegisterXLL(Filename)
Repeat()
ReplaceFormat [= setting]
ResetTipWizard()
RollZoom [= setting]
Rows
RTD
Run([Macro], [Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
Save([Filename])
SaveWorkspace([Filename])
ScreenUpdating [= setting]
Selection
SendKeys(Keys, [Wait])
SetDefaultChart([FormatName], [Gallery])
SheetActivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetPivotTableUpdate
Sheets
SheetSelectionChange
SheetsInNewWorkbook [= setting]
ShortcutMenus
ShowChartTipNames [= setting]
ShowChartTipValues [= setting]
ShowStartupDialog [= setting]
ShowToolTips [= setting]
ShowWindowsInTaskbar [= setting]
SmartTagRecognizers
Speech
SpellingOptions
StandardFont [= setting]
StandardFontSize [= setting]
StartupPath
StatusBar [= setting]
Support(Object, ID, [arg])
TemplatesPath
ThisCell
ThisWorkbook
ThousandsSeparator [= setting]
Toolbars
Top [= setting]
ToString()
TransitionMenuKey [= setting]
TransitionMenuKeyAction [= setting]
TransitionNavigKeys [= setting]
UILanguage [= setting]
Undo()
Union(Arg1, Arg2, [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])
UsableHeight
UsableWidth
UsedObjects
UserControl [= setting]
UserLibraryPath
UserName [= setting]
UseSystemSeparators [= setting]
Value
VBE
Version
Visible [= setting]
Volatile([Volatile])
Wait(Time)
Watches
Width [= setting]
WindowActivate
WindowDeactivate
WindowResize
Windows
WindowsForPens
WindowState [= setting]
WorkbookActivate
WorkbookAddinInstall
WorkbookAddinUninstall
WorkbookAfterXmlExport
WorkbookAfterXmlImport
WorkbookBeforeClose
WorkbookBeforePrint
WorkbookBeforeSave
WorkbookBeforeXmlExport
WorkbookBeforeXmlImport
WorkbookDeactivate
WorkbookNewSheet
WorkbookOpen
WorkbookPivotTableCloseConnection
WorkbookPivotTableOpenConnection
Workbooks
WorkbookSync
WorksheetFunction
Worksheets

Areas (1995) A collection of the areas, or contiguous blocks of cells, within a selection. Theres no singular Area object; individual members of the Areas collection are Range objects. The Areas collection contains one Range object for each discrete, contiguous range of cells within the selection. If the selection contains only one area, the Areas collection contains a single Range object that corresponds to that selection.

Application
Count
Creator
GetEnumerator()
Item
Parent

AutoCorrect (1995) Contains Microsoft Excel AutoCorrect attributes (capitalization of names of days, correction of two initial capital letters, automatic correction list, and so on).

AddReplacement(What, Replacement)
Application
AutoExpandListRange [= setting]
CapitalizeNamesOfDays [= setting]
CorrectCapsLock [= setting]
CorrectSentenceCap [= setting]
Creator
DeleteReplacement(What)
DisplayAutoCorrectOptions [= setting]
Parent
ReplacementList [= setting]
ReplaceText [= setting]
TwoInitialCapitals [= setting]

AutoFilter (1995) Represents autofiltering for the specified worksheet.

Application
Creator
Filters
Parent
Range

AutoRecover (2002) Use the Path property of the AutoRecover object to set the path for where the AutoRecover file will be saved. The following example sets the path of the AutoRecover file to drive C.

Application
Creator
Enabled [= setting]
Parent
Path [= setting]
Time [= setting]

Axes (1995) A collection of all the Axis objects in the specified chart.

Application
Count
Creator
GetEnumerator()
Item(Type, [AxisGroup])
Parent

Axis (1995) Represents a single axis in a chart. The Axis object is a member of the Axes collection.

Application
AxisBetweenCategories [= setting]
AxisGroup
AxisTitle
BaseUnit [= setting]
BaseUnitIsAuto [= setting]
Border
CategoryNames [= setting]
CategoryType [= setting]
Creator
Crosses [= setting]
CrossesAt [= setting]
Delete()
DisplayUnit [= setting]
DisplayUnitCustom [= setting]
DisplayUnitLabel
HasDisplayUnitLabel [= setting]
HasMajorGridlines [= setting]
HasMinorGridlines [= setting]
HasTitle [= setting]
Height
Left
MajorGridlines
MajorTickMark [= setting]
MajorUnit [= setting]
MajorUnitIsAuto [= setting]
MajorUnitScale [= setting]
MaximumScale [= setting]
MaximumScaleIsAuto [= setting]
MinimumScale [= setting]
MinimumScaleIsAuto [= setting]
MinorGridlines
MinorTickMark [= setting]
MinorUnit [= setting]
MinorUnitIsAuto [= setting]
MinorUnitScale [= setting]
Parent
ReversePlotOrder [= setting]
ScaleType [= setting]
Select()
TickLabelPosition [= setting]
TickLabels
TickLabelSpacing [= setting]
TickMarkSpacing [= setting]
Top
Type [= setting]
Width

AxisTitle (1995) Represents a chart axis title.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

Border (1995) Represents the border of an object.

Application
Color [= setting]
ColorIndex [= setting]
Creator
LineStyle [= setting]
Parent
Weight [= setting]

Borders (1995) A collection of four Style object.

Application
Color [= setting]
ColorIndex [= setting]
Count
Creator
GetEnumerator()
Item
LineStyle [= setting]
Parent
Value [= setting]
Weight [= setting]

CalculatedFields (1997) A collection of PivotField objects that represents all the calculated fields in the specified PivotTable report. For example, a report that contains Revenue and Expense fields could have a calculated field named Profit defined as the amount in the Revenue field minus the amount in the Expense field.

Add(Name, Formula, [UseStandardFormula])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

CalculatedItems (1997) A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report. For example, a PivotTable report that contains January, February, and March items could have a calculated item named FirstQuarter defined as the sum of the amounts in January, February, and March.

Add(Name, Formula, [UseStandardFormula])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

CalculatedMember (2002) Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

Application
Creator
Delete()
Formula
IsValid
Name
Parent
SolveOrder
SourceName
Type

CalculatedMembers (2002) A collection of all the CalculatedMember objects on the specified PivotTable. Each CalculatedMember object represents a calculated field or calculated item.

Add(Name, Formula, [SolveOrder], [Type])
Application
Count
Creator
GetEnumerator()
Item
Parent

CalloutFormat (1997) Contains properties and methods that apply to line callouts.

Accent [= setting]
Angle [= setting]
Application
AutoAttach [= setting]
AutoLength
AutomaticLength()
Border [= setting]
Creator
CustomDrop(Drop)
CustomLength(Length)
Drop
DropType
Gap [= setting]
Length
Parent
PresetDrop(DropType)
Type [= setting]

CellFormat (2002) Represents the search criteria for the cell format.

AddIndent [= setting]
Application
Borders [= setting]
Clear()
Creator
Font [= setting]
FormulaHidden [= setting]
HorizontalAlignment [= setting]
IndentLevel [= setting]
Interior [= setting]
Locked [= setting]
MergeCells [= setting]
NumberFormat [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
ShrinkToFit [= setting]
VerticalAlignment [= setting]
WrapText [= setting]

Characters (1995) Represents characters in an object that contains text. The Characters object lets you modify any sequence of characters contained in the full text string.

Application
Caption [= setting]
Count
Creator
Delete()
Font
Insert(String)
Parent
PhoneticCharacters [= setting]
Text [= setting]

Chart (1995) Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.

Activate()
Application
ApplyCustomType(ChartType, [TypeName])
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
Arcs([Index])
Area3DGroup
AreaGroups([Index])
AutoFormat(Gallery, [Format])
AutoScaling [= setting]
Axes([Type], [AxisGroup])
Bar3DGroup
BarGroups([Index])
BarShape [= setting]
BeforeDoubleClick
BeforeRightClick
Buttons([Index])
Calculate
ChartArea
ChartEvents_Event_Activate
ChartEvents_Event_Select
ChartGroups([Index])
ChartObjects([Index])
ChartTitle
ChartType [= setting]
ChartWizard([Source], [Gallery], [Format], [PlotBy], [CategoryLabels], [SeriesLabels], [HasLegend], [Title], [CategoryTitle], [ValueTitle], [ExtraTitle])
CheckBoxes([Index])
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
CodeName
Column3DGroup
ColumnGroups([Index])
Copy([Before], [After])
CopyChartBuild()
CopyPicture([Appearance], [Format], [Size])
Corners
CreateObjRef(requestedType)
CreatePublisher([Edition], [Appearance], [Size], [ContainsPICT], [ContainsBIFF], [ContainsRTF], [ContainsVALU])
Creator
DataTable
Deactivate
Delete()
DepthPercent [= setting]
Deselect()
DisplayBlanksAs [= setting]
DoughnutGroups([Index])
DragOver
DragPlot
DrawingObjects([Index])
Drawings([Index])
DropDowns([Index])
Elevation [= setting]
Equals(obj)
Evaluate(Name)
Export(Filename, [FilterName], [Interactive])
Floor
GapDepth [= setting]
GetChartElement(x, y, ElementID, Arg1, Arg2)
GetHashCode()
GetLifetimeService()
GetType()
GroupBoxes([Index])
GroupObjects([Index])
HasAxis [= setting]
HasDataTable [= setting]
HasLegend [= setting]
HasPivotFields [= setting]
HasTitle [= setting]
HeightPercent [= setting]
Hyperlinks
Index
InitializeLifetimeService()
Labels([Index])
Legend
Line3DGroup
LineGroups([Index])
Lines([Index])
ListBoxes([Index])
Location(Where, [Name])
MailEnvelope
MouseDown
MouseMove
MouseUp
Move([Before], [After])
Name [= setting]
Next
OLEObjects([Index])
OnDoubleClick [= setting]
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
OptionButtons([Index])
Ovals([Index])
PageSetup
Parent
Paste([Type])
Perspective [= setting]
Pictures([Index])
Pie3DGroup
PieGroups([Index])
PivotLayout
PlotArea
PlotBy [= setting]
PlotVisibleOnly [= setting]
Previous
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly])
ProtectContents
ProtectData [= setting]
ProtectDrawingObjects
ProtectFormatting [= setting]
ProtectGoalSeek [= setting]
ProtectionMode
ProtectSelection [= setting]
RadarGroups([Index])
Rectangles([Index])
Refresh()
Resize
RightAngleAxes [= setting]
Rotation [= setting]
SaveAs(Filename, [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
Scripts
ScrollBars([Index])
Select([Replace])
SeriesChange
SeriesCollection([Index])
SetBackgroundPicture(Filename)
SetSourceData(Source, [PlotBy])
Shapes
ShowWindow [= setting]
SizeWithWindow [= setting]
Spinners([Index])
SubType [= setting]
SurfaceGroup
Tab
TextBoxes([Index])
ToString()
Type [= setting]
Unprotect([Password])
Visible [= setting]
Walls
WallsAndGridlines2D [= setting]
XYGroups([Index])

ChartArea (1995) Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesnt include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.

Application
AutoScaleFont [= setting]
Border
Clear()
ClearContents()
ClearFormats()
Copy()
Creator
Fill
Font
Height [= setting]
Interior
Left [= setting]
Name
Parent
Select()
Shadow [= setting]
Top [= setting]
Width [= setting]

ChartColorFormat (1997) Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.

Application
Creator
Parent
RGB
SchemeColor [= setting]
Type

ChartEvents (1997) Hidden or unsupported element.

Activate()
BeforeDoubleClick(ElementID, Arg1, Arg2, Cancel)
BeforeRightClick(Cancel)
Calculate()
Deactivate()
DragOver()
DragPlot()
MouseDown(Button, Shift, x, y)
MouseMove(Button, Shift, x, y)
MouseUp(Button, Shift, x, y)
Resize()
Select(ElementID, Arg1, Arg2)
SeriesChange(SeriesIndex, PointIndex)

ChartFillFormat (1997) Used only with charts. Represents fill formatting for chart elements.

Application
BackColor
Creator
ForeColor
GradientColorType
GradientDegree
GradientStyle
GradientVariant
OneColorGradient(Style, Variant, Degree)
Parent
Pattern
Patterned(Pattern)
PresetGradient(Style, Variant, PresetGradientType)
PresetGradientType
PresetTexture
PresetTextured(PresetTexture)
Solid()
TextureName
TextureType
TwoColorGradient(Style, Variant)
Type
UserPicture([PictureFile], [PictureFormat], [PictureStackUnit], [PicturePlacement])
UserTextured(TextureFile)
Visible [= setting]

ChartGroup (1995) Represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more ChartGroups collection.

Application
AxisGroup [= setting]
BubbleScale [= setting]
Creator
DoughnutHoleSize [= setting]
DownBars
DropLines
FirstSliceAngle [= setting]
GapWidth [= setting]
Has3DShading [= setting]
HasDropLines [= setting]
HasHiLoLines [= setting]
HasRadarAxisLabels [= setting]
HasSeriesLines [= setting]
HasUpDownBars [= setting]
HiLoLines
Index
Overlap [= setting]
Parent
RadarAxisLabels
SecondPlotSize [= setting]
SeriesCollection([Index])
SeriesLines
ShowNegativeBubbles [= setting]
SizeRepresents [= setting]
SplitType [= setting]
SplitValue [= setting]
SubType [= setting]
Type [= setting]
UpBars
VaryByCategories [= setting]

ChartGroups (1995) A collection of all the ChartGroup objects in the specified chart. Each ChartGroup object represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more series, and each series contains one or more points. For example, a single chart might contain both a line chart group, containing all the series plotted with the line chart format, and a bar chart group, containing all the series plotted with the bar chart format.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

ChartObject (1995) Represents an embedded chart on a worksheet. The ChartObject object acts as a container for a ChartObjects collection. The ChartObjects collection contains all the embedded charts on a single sheet.

Activate()
Application
Border
BottomRightCell
BringToFront()
Chart
Copy()
CopyPicture([Appearance], [Format])
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
Height [= setting]
Index
Interior
Left [= setting]
Locked [= setting]
Name [= setting]
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
ProtectChartObject [= setting]
RoundedCorners [= setting]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
Top [= setting]
TopLeftCell
Visible [= setting]
Width [= setting]
ZOrder

ChartObjects (1995) A collection of all the Chart object. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the sheet.

Add(Left, Top, Width, Height)
Application
Border
BringToFront()
Copy()
CopyPicture([Appearance], [Format])
Count
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
GetEnumerator()
Group()
Height [= setting]
Interior
Item(Index)
Left [= setting]
Locked [= setting]
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
RoundedCorners [= setting]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
Top [= setting]
Visible [= setting]
Width [= setting]

Charts (1995) A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesnt include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.

Add([Before], [After], [Count])
Application
Copy([Before], [After])
Count
Creator
Delete()
GetEnumerator()
HPageBreaks
Item
Move([Before], [After])
Parent
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Select([Replace])
Visible [= setting]
VPageBreaks

ChartTitle (1995) Represents the chart title.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

ColorFormat (1997) Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the SchemeColor property).

Application
Creator
Parent
RGB [= setting]
SchemeColor [= setting]
TintAndShade [= setting]
Type

Comment (1997) Represents a cell comment. The Comment object is a member of the Comments collection.

Application
Author
Creator
Delete()
Next()
Parent
Previous()
Shape
Text([Text], [Start], [Overwrite])
Visible [= setting]

Comments (1997) A collection of cell comments. Each comment is represented by a Comment object.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

ConnectorFormat (1995) Contains properties and methods that apply to connectors. A connector is a line that attaches two other shapes at points called connection sites. If you rearrange shapes that are connected, the geometry of the connector will be automatically adjusted so that the shapes remain connected.

Application
BeginConnect(ConnectedShape, ConnectionSite)
BeginConnected
BeginConnectedShape
BeginConnectionSite
BeginDisconnect()
Creator
EndConnect(ConnectedShape, ConnectionSite)
EndConnected
EndConnectedShape
EndConnectionSite
EndDisconnect()
Parent
Type [= setting]

ControlFormat (1997) Contains Microsoft Excel control properties.

AddItem(Text, [Index])
Application
Creator
DropDownLines [= setting]
Enabled [= setting]
LargeChange [= setting]
LinkedCell [= setting]
List
ListCount [= setting]
ListFillRange [= setting]
ListIndex [= setting]
LockedText [= setting]
Max [= setting]
Min [= setting]
MultiSelect [= setting]
Parent
PrintObject [= setting]
RemoveAllItems()
RemoveItem(Index, [Count])
SmallChange [= setting]
Value [= setting]

Corners (1995) Represents the corners of a 3-D chart. This object isnt a collection.

Application
Creator
Name
Parent
Select()

CubeField (2000) Represents a hierarchy or measure field from an CubeFields collection.

AddMemberPropertyField(Property, [PropertyOrder])
Application
Caption
Creator
CubeFieldType
Delete()
DragToColumn [= setting]
DragToData [= setting]
DragToHide [= setting]
DragToPage [= setting]
DragToRow [= setting]
EnableMultiplePageItems [= setting]
HasMemberProperties
HiddenLevels [= setting]
LayoutForm [= setting]
LayoutSubtotalLocation [= setting]
Name
Orientation [= setting]
Parent
PivotFields
Position [= setting]
ShowInFieldList [= setting]
TreeviewControl
Value

CubeFields (2000) A collection of all cube. Each CubeField object represents a hierarchy or measure field from the cube.

AddSet(Name, Caption)
Application
Count
Creator
GetEnumerator()
Item
Parent

CustomProperties (2002) A collection of CustomProperty objects that represent additional information. The information can be used as metadata for XML.

Add(Name, Value)
Application
Count
Creator
GetEnumerator()
Item
Parent

CustomProperty (2002) Represents identifier information. Identifier information can be used as metadata for XML.

Application
Creator
Delete()
Name [= setting]
Parent
Value [= setting]

CustomView (1997) Represents a custom workbook view. The CustomView object is a member of the CustomViews collection.

Application
Creator
Delete()
Name
Parent
PrintSettings
RowColSettings
Show()

CustomViews (1997) A collection of custom workbook views. Each view is represented by a CustomView object.

Add(ViewName, [PrintSettings], [RowColSettings])
Application
Count
Creator
GetEnumerator()
Item(ViewName)
Parent

DataLabel (1995) Represents the data label on a chart point or trendline. On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object.

Application
AutoScaleFont [= setting]
AutoText [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
Position [= setting]
ReadingOrder [= setting]
Select()
Separator [= setting]
Shadow [= setting]
ShowBubbleSize [= setting]
ShowCategoryName [= setting]
ShowLegendKey [= setting]
ShowPercentage [= setting]
ShowSeriesName [= setting]
ShowValue [= setting]
Text [= setting]
Top [= setting]
Type [= setting]
VerticalAlignment [= setting]

DataLabels (1995) A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.

Application
AutoScaleFont [= setting]
AutoText [= setting]
Border
Count
Creator
Delete()
Fill
Font
GetEnumerator()
HorizontalAlignment [= setting]
Interior
Item(Index)
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
Position [= setting]
ReadingOrder [= setting]
Select()
Separator [= setting]
Shadow [= setting]
ShowBubbleSize [= setting]
ShowCategoryName [= setting]
ShowLegendKey [= setting]
ShowPercentage [= setting]
ShowSeriesName [= setting]
ShowValue [= setting]
Type [= setting]
VerticalAlignment [= setting]

DataTable (1997) Represents a chart data table.

Application
AutoScaleFont [= setting]
Border
Creator
Delete()
Font
HasBorderHorizontal [= setting]
HasBorderOutline [= setting]
HasBorderVertical [= setting]
Parent
Select()
ShowLegendKey [= setting]

DefaultWebOptions (2000) Contains global application-level attributes used by Microsoft Excel when you save a document as a Web page or open a Web page. You can return or set attributes either at the application (global) level or at the workbook level. (Note that attribute values can be different from one workbook to another, depending on the attribute value at the time the workbook was saved.) Workbook-level attribute settings override application-level attribute settings. Workbook-level attributes are contained in the WebOptions object.

AllowPNG [= setting]
AlwaysSaveInDefaultEncoding [= setting]
Application
CheckIfOfficeIsHTMLEditor [= setting]
Creator
DownloadComponents [= setting]
Encoding [= setting]
FolderSuffix
Fonts
LoadPictures [= setting]
LocationOfComponents [= setting]
OrganizeInFolder [= setting]
Parent
PixelsPerInch [= setting]
RelyOnCSS [= setting]
RelyOnVML [= setting]
SaveHiddenData [= setting]
SaveNewWebPagesAsWebArchives [= setting]
ScreenSize [= setting]
TargetBrowser [= setting]
UpdateLinksOnSave [= setting]
UseLongFileNames [= setting]

Diagram (2002) Represents a diagram.

Application
AutoFormat [= setting]
AutoLayout [= setting]
Convert(Type)
Creator
FitText()
Nodes
Parent
Reverse [= setting]
Type

DiagramNode (2002) Hidden or unsupported element.

AddNode([pos], [nodeType])
Application
Children
CloneNode(copyChildren, pTargetNode, [pos])
Creator
Delete()
Diagram
Layout [= setting]
MoveNode(pTargetNode, pos)
NextNode()
Parent
PrevNode()
ReplaceNode(pTargetNode)
Root
Shape
SwapNode(pTargetNode, [swapChildren])
TextShape
TransferChildren(pReceivingNode)

DiagramNodeChildren (2002) Hidden or unsupported element.

AddNode([Index], [nodeType])
Application
Count
Creator
FirstChild
GetEnumerator()
Item(Index)
LastChild
Parent
SelectAll()

DiagramNodes (2002) Hidden or unsupported element.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent
SelectAll()

Dialog (1995) Represents a built-in Microsoft Excel dialog box. The Dialog object is a member of the Show method to display the corresponding dialog box.

Application
Creator
Parent
Show([Arg1], [Arg2], [Arg3], [Arg4], [Arg5], [Arg6], [Arg7], [Arg8], [Arg9], [Arg10], [Arg11], [Arg12], [Arg13], [Arg14], [Arg15], [Arg16], [Arg17], [Arg18], [Arg19], [Arg20], [Arg21], [Arg22], [Arg23], [Arg24], [Arg25], [Arg26], [Arg27], [Arg28], [Arg29], [Arg30])

Dialogs (1995) A collection of all the Show method to display the dialog corresponding dialog box.

Application
Count
Creator
GetEnumerator()
Item
Parent

DisplayUnitLabel (2000) Represents a unit label on an axis in the specified chart. Unit labels are useful for charting large valuesfor example, in the millions or billions. You can make the chart more readable by using a single unit label instead of large numbers at each tick mark.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

DocEvents (1997) Hidden or unsupported element.

Activate()
BeforeDoubleClick(Target, Cancel)
BeforeRightClick(Target, Cancel)
Calculate()
Change(Target)
Deactivate()
FollowHyperlink(Target)
PivotTableUpdate(Target)
SelectionChange(Target)

DownBars (1995) Represents the down bars in a chart group. Down bars connect points on the first series in the chart group with lower values on the last series (the lines go down from the first series). Only 2-D line groups that contain at least two series can have down bars. This object isnt a collection. Theres no object that represents a single down bar; you either have up bars and down bars turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Fill
Interior
Name
Parent
Select()

DropLines (1995) Represents the drop lines in a chart group. Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. This object isnt a collection. Theres no object that represents a single drop line; you either have drop lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

Error (2002) Represents a spreadsheet error for a range.

Application
Creator
Ignore [= setting]
Parent
Value

ErrorBars (1995) Represents the error bars on a chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isnt a collection. Theres no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.

Application
Border
ClearFormats()
Creator
Delete()
EndStyle [= setting]
Name
Parent
Select()

ErrorCheckingOptions (2002) Represents the error-checking options for an application.

Application
BackgroundChecking [= setting]
Creator
EmptyCellReferences [= setting]
EvaluateToError [= setting]
InconsistentFormula [= setting]
IndicatorColorIndex [= setting]
ListDataValidation [= setting]
NumberAsText [= setting]
OmittedCells [= setting]
Parent
TextDate [= setting]
UnlockedFormulaCells [= setting]

Errors (2002) Represents the various spreadsheet errors for a range.

Application
Creator
Item
Parent

FillFormat (1997) Represents fill formatting for a shape. A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill.

Application
BackColor [= setting]
Background()
Creator
ForeColor [= setting]
GradientColorType
GradientDegree
GradientStyle
GradientVariant
OneColorGradient(Style, Variant, Degree)
Parent
Pattern
Patterned(Pattern)
PresetGradient(Style, Variant, PresetGradientType)
PresetGradientType
PresetTexture
PresetTextured(PresetTexture)
Solid()
TextureName
TextureType
Transparency [= setting]
TwoColorGradient(Style, Variant)
Type
UserPicture(PictureFile)
UserTextured(TextureFile)
Visible [= setting]

Filter (2000) Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.

Application
Creator
Criteria1
Criteria2
On
Operator
Parent

Filters (2000) A collection of Filter objects that represents all the filters in an autofiltered range.

Application
Count
Creator
GetEnumerator()
Item
Parent

Floor (2000) Represents the floor of a 3-D chart

Application
Border
ClearFormats()
Creator
Fill
Interior
Name
Parent
Paste()
PictureType [= setting]
Select()

Font (2000) Contains the font attributes (font name, font size, color, and so on) for an object.

Application
Background [= setting]
Bold [= setting]
Color [= setting]
ColorIndex [= setting]
Creator
FontStyle [= setting]
Italic [= setting]
Name [= setting]
OutlineFont [= setting]
Parent
Shadow [= setting]
Size [= setting]
Strikethrough [= setting]
Subscript [= setting]
Superscript [= setting]
Underline [= setting]

FormatCondition (1997) Represents a conditional format. The FormatCondition object is a member of the FormatConditions collection. The FormatConditions collection can contain up to three conditional formats for a given range.

Application
Borders
Creator
Delete()
Font
Formula1
Formula2
Interior
Modify(Type, [Operator], [Formula1], [Formula2])
Operator
Parent
Type

FormatConditions (1997) Represents the collection of conditional formats for a single range. The FormatConditions collection can contain up to three conditional formats. Each format is represented by a FormatCondition object.

Add(Type, [Operator], [Formula1], [Formula2])
Application
Count
Creator
Delete()
GetEnumerator()
Item(Index)
Parent

FreeformBuilder (1997) Represents the geometry of a freeform while its being built.

AddNodes(SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3])
Application
ConvertToShape()
Creator
Parent

Graphic (2002) Contains properties that apply to header and footer picture objects.

Application
Brightness [= setting]
ColorType [= setting]
Contrast [= setting]
Creator
CropBottom [= setting]
CropLeft [= setting]
CropRight [= setting]
CropTop [= setting]
Filename [= setting]
Height [= setting]
LockAspectRatio [= setting]
Parent
Width [= setting]

Gridlines (1995) Represents major or minor gridlines on a chart axis. Gridlines extend the tick marks on a chart axis to make it easier to see the values associated with the data markers. This object isnt a collection. Theres no object that represents a single gridline; you either have all gridlines for an axis turned on or all of them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

GroupShapes (1997) Represents the individual shapes within a grouped shape. Each shape is represented by a Item method with this object, you can work with single shapes within a group without having to ungroup them.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent
Range

HiLoLines (1995) Represents the high-low lines in a chart group. High-low lines connect the highest point with the lowest point in every category in the chart group. Only 2-D line groups can have high-low lines. This object isnt a collection. Theres no object that represents a single high-low line; you either have high-low lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

HPageBreak (1997) Represents a horizontal page break. The HPageBreak object is a member of the HPageBreaks collection.

Application
Creator
Delete()
DragOff(Direction, RegionIndex)
Extent
Location [= setting]
Parent
Type [= setting]

HPageBreaks (1997) The collection of horizontal page breaks within the print area. Each horizontal page break is represented by an HPageBreak object.

Add(Before)
Application
Count
Creator
GetEnumerator()
Item
Parent

Hyperlink (1997) Represents a hyperlink. The Hyperlink object is a member of the Hyperlinks collection.

Address [= setting]
AddToFavorites()
Application
CreateNewDocument(Filename, EditNow, Overwrite)
Creator
Delete()
EmailSubject [= setting]
Follow([NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
Name
Parent
Range
ScreenTip [= setting]
Shape
SubAddress [= setting]
TextToDisplay [= setting]
Type

Hyperlinks (1997) Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by a Hyperlink object.

Add(Anchor, Address, [SubAddress], [ScreenTip], [TextToDisplay])
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent

Interior (1995) Represents the interior of an object.

Application
Color [= setting]
ColorIndex [= setting]
Creator
InvertIfNegative [= setting]
Parent
Pattern [= setting]
PatternColor [= setting]
PatternColorIndex [= setting]

IRtdServer (2002) Represents an interface for a real-time data server.

ConnectData(TopicID, Strings, GetNewValues)
DisconnectData(TopicID)
Heartbeat()
RefreshData(TopicCount)
ServerStart(CallbackObject)
ServerTerminate()

IRTDUpdateEvent (2002) Represents real-time data update events.

Disconnect()
HeartbeatInterval [= setting]
UpdateNotify()

Label (1995) Hidden or unsupported element.

Accelerator [= setting]
Application
BottomRightCell
BringToFront()
Caption [= setting]
Characters
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
Copy()
CopyPicture([Appearance], [Format])
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
Height [= setting]
Index
Left [= setting]
Locked [= setting]
LockedText [= setting]
Name [= setting]
OnAction [= setting]
Parent
PhoneticAccelerator [= setting]
Placement [= setting]
PrintObject [= setting]
Select([Replace])
SendToBack()
ShapeRange
Text [= setting]
Top [= setting]
TopLeftCell
Visible [= setting]
Width [= setting]
ZOrder

Labels (1995) Hidden or unsupported element.

Accelerator [= setting]
Add(Left, Top, Width, Height)
Application
BringToFront()
Caption [= setting]
Characters
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
Copy()
CopyPicture([Appearance], [Format])
Count
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
GetEnumerator()
Group()
Height [= setting]
Item(Index)
Left [= setting]
Locked [= setting]
LockedText [= setting]
OnAction [= setting]
Parent
PhoneticAccelerator [= setting]
Placement [= setting]
PrintObject [= setting]
Select([Replace])
SendToBack()
ShapeRange
Text [= setting]
Top [= setting]
Visible [= setting]
Width [= setting]