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]
ZOrder

LeaderLines (1997) Represents leader lines on a chart. Leader lines connect data labels to data points. This object isnt a collection; theres no object that represents a single leader line.

Application
Border
Creator
Delete()
Parent
Select()

Legend (1995) Represents the legend in a chart. Each chart can have only one legend. The Legend object contains one or more LegendKey object.

Application
AutoScaleFont [= setting]
Border
Clear()
Creator
Delete()
Fill
Font
Height [= setting]
Interior
Left [= setting]
LegendEntries([Index])
Name
Parent
Position [= setting]
Select()
Shadow [= setting]
Top [= setting]
Width [= setting]

LegendEntries (1995) A collection of all the LegendKey object.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

LegendEntry (1995) Represents a legend entry in a chart legend. The LegendEntry object is a member of the LegendEntries collection. The LegendEntries collection contains all the LegendEntry objects in the legend.

Application
AutoScaleFont [= setting]
Creator
Delete()
Font
Height
Index
Left
LegendKey
Parent
Select()
Top
Width

LegendKey (1995) Represents a legend key in a chart legend. Each legend key is a graphic that visually links a legend entry with its associated series or trendline in the chart. The legend key is linked to its associated series or trendline in such a way that changing the formatting of one simultaneously changes the formatting of the other.

Application
Border
ClearFormats()
Creator
Delete()
Fill
Height
Interior
InvertIfNegative [= setting]
Left
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Parent
PictureType [= setting]
PictureUnit [= setting]
Select()
Shadow [= setting]
Smooth [= setting]
Top
Width

LineFormat (1997) Represents line and arrowhead formatting. For a line, the LineFormat object contains formatting information for the line itself; for a shape with a border, this object contains formatting information for the shape border.

Application
BackColor [= setting]
BeginArrowheadLength [= setting]
BeginArrowheadStyle [= setting]
BeginArrowheadWidth [= setting]
Creator
DashStyle [= setting]
EndArrowheadLength [= setting]
EndArrowheadStyle [= setting]
EndArrowheadWidth [= setting]
ForeColor [= setting]
Parent
Pattern [= setting]
Style [= setting]
Transparency [= setting]
Visible [= setting]
Weight [= setting]

LinkFormat (1995) Contains linked OLE object properties.

Application
AutoUpdate [= setting]
Creator
Locked [= setting]
Parent
Update()

ListColumn (2003) Represents a column in a ListObject object).

Application
Creator
Delete()
Index
ListDataFormat
Name [= setting]
Parent
Range
SharePointFormula
TotalsCalculation [= setting]
XPath

ListColumns (2003) A collection of all the ListColumn objects in the specified ListColumn object represents a column in the list.

Add([Position])
Application
Count
Creator
GetEnumerator()
Item
Parent

ListDataFormat (2003) The ListColumn object. These properties are read-only.

AllowFillIn
Application
Choices
Creator
DecimalPlaces
DefaultValue
IsPercent
lcid
MaxCharacters
MaxNumber
MinNumber
Parent
ReadOnly
Required
Type

ListObject (2003) Represents a list object on a worksheet. The ListObjects collection contains all the list objects on a worksheet.

Active
Application
Creator
DataBodyRange
Delete()
DisplayRightToLeft
HeaderRowRange
InsertRowRange
ListColumns
ListRows
Name [= setting]
Parent
Publish(Target, LinkSource)
QueryTable
Range
Refresh()
Resize(Range)
SharePointURL
ShowAutoFilter [= setting]
ShowTotals [= setting]
SourceType
TotalsRowRange
Unlink()
Unlist()
UpdateChanges([iConflictType])
XmlMap

ListObjects (2003) A collection of all the ListObject objects on a worksheet. Each ListObject object represents a list in the worksheet.

Add([SourceType], [Source], [LinkSource], [XlListObjectHasHeaders], [Destination])
Application
Count
Creator
GetEnumerator()
Item
Parent

ListRow (2003) Represents a row in a List object. The ListRow object is a member of the ListRows collection contains all the rows in a list object.

Application
Creator
Delete()
Index
InvalidData
Parent
Range

ListRows (2003) A collection of all the ListRow objects in the specified ListRow object represents a row in the list.

Add([Position])
Application
Count
Creator
GetEnumerator()
Item
Parent

Mailer (1995) Hidden or unsupported element.

Application
BCCRecipients [= setting]
CCRecipients [= setting]
Creator
Enclosures [= setting]
Parent
Received
SendDateTime
Sender
Subject [= setting]
ToRecipients [= setting]
WhichAddress [= setting]

Name (1995) Represents a defined name for a range of cells. Names can be either built-in names  such as Database, Print_Area, and Auto_Open  or custom names.

Application
Category [= setting]
CategoryLocal [= setting]
Creator
Delete()
Index
MacroType [= setting]
Name [= setting]
NameLocal [= setting]
Parent
RefersTo [= setting]
RefersToLocal [= setting]
RefersToR1C1 [= setting]
RefersToR1C1Local [= setting]
RefersToRange
ShortcutKey [= setting]
Value [= setting]
Visible [= setting]

Names (1995) A collection of all the Name objects in the application or workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names  such as Database, Print_Area, and Auto_Open  or custom names.

Add([Name], [RefersTo], [Visible], [MacroType], [ShortcutKey], [Category], [NameLocal], [RefersToLocal], [CategoryLocal], [RefersToR1C1], [RefersToR1C1Local])
Application
Count
Creator
GetEnumerator()
Item([Index], [IndexLocal], [RefersTo])
Parent

ODBCError (1997) Represents an ODBC error generated by the most recent ODBC query. The ODBCError object is a member of the ODBCErrors collection. If the specified ODBC query runs without error, the ODBCErrors collection is empty. The errors in the collection are indexed in the order in which theyre generated by the ODBC data source.

Application
Creator
ErrorString
Parent
SqlState

ODBCErrors (1997) A collection of ODBCError objects. Each ODBCError object represents an error returned by the most recent ODBC query. If the specified ODBC query runs without error, the ODBCErrors collection is empty. The errors in the collection are indexed in the order in which theyre generated by the ODBC data source. You cannot add members to the collection.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

OLEDBError (2000) Represents an OLE DB error returned by the most recent OLE DB query. The OLEDBError object is a member of the OLEDBErrors collection. If the specified OLE DB query runs without error, the OLEDBErrors collection is empty. The errors in the collection are indexed in the order in which they are generated by the OLE DB provider.

Application
Creator
ErrorString
Native
Number
Parent
SqlState
Stage

OLEDBErrors (2000) A collection of OLEDBError objects. Each OLEDBError object represents an error returned by the most recent OLE DB query. If the specified OLE DB query runs without error, the OLEDBErrors collection is empty. The errors in the collection are indexed in the order in which they are generated by the OLE DB provider. You cannot add members to the collection.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

OLEFormat (1997) Contains OLE object properties.

Activate()
Application
Creator
Object
Parent
progID
Verb([Verb])

OLEObject (1995) Represents an ActiveX control or a linked or embedded OLE object on a worksheet. The OLEObject object is a member of the OLEObjects collection. The OLEObjects collection contains all the OLE objects on a single worksheet.

Activate()
AltHTML [= setting]
Application
AutoLoad [= setting]
AutoUpdate [= setting]
Border
BottomRightCell
BringToFront()
Copy()
CopyPicture([Appearance], [Format])
CreateObjRef(requestedType)
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
Equals(obj)
GetHashCode()
GetLifetimeService()
GetType()
GotFocus
Height [= setting]
Index
InitializeLifetimeService()
Interior
Left [= setting]
LinkedCell [= setting]
ListFillRange [= setting]
Locked [= setting]
LostFocus
Name [= setting]
Object
OLEType
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
progID
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
SourceName [= setting]
Top [= setting]
TopLeftCell
ToString()
Update()
Verb([Verb])
Visible [= setting]
Width [= setting]
ZOrder

OLEObjectEvents (1995) Hidden or unsupported element.

GotFocus()
LostFocus()

OLEObjects (1995) A collection of all the OLEObject objects on the specified worksheet. Each OLEObject object represents an ActiveX control or a linked or embedded OLE object.

Add([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])
Application
AutoLoad [= setting]
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]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
SourceName [= setting]
Top [= setting]
Visible [= setting]
Width [= setting]
ZOrder

Outline (1995) Represents an outline on a worksheet.

Application
AutomaticStyles [= setting]
Creator
Parent
ShowLevels([RowLevels], [ColumnLevels])
SummaryColumn [= setting]
SummaryRow [= setting]

PageSetup (1995) Represents the page setup description. The PageSetup object contains all page setup attributes (left margin, bottom margin, paper size, and so on) as properties.

Application
BlackAndWhite [= setting]
BottomMargin [= setting]
CenterFooter [= setting]
CenterFooterPicture
CenterHeader [= setting]
CenterHeaderPicture
CenterHorizontally [= setting]
CenterVertically [= setting]
ChartSize [= setting]
Creator
Draft [= setting]
FirstPageNumber [= setting]
FitToPagesTall [= setting]
FitToPagesWide [= setting]
FooterMargin [= setting]
HeaderMargin [= setting]
LeftFooter [= setting]
LeftFooterPicture
LeftHeader [= setting]
LeftHeaderPicture
LeftMargin [= setting]
Order [= setting]
Orientation [= setting]
PaperSize [= setting]
Parent
PrintArea [= setting]
PrintComments [= setting]
PrintErrors [= setting]
PrintGridlines [= setting]
PrintHeadings [= setting]
PrintNotes [= setting]
PrintQuality [= setting]
PrintTitleColumns [= setting]
PrintTitleRows [= setting]
RightFooter [= setting]
RightFooterPicture
RightHeader [= setting]
RightHeaderPicture
RightMargin [= setting]
TopMargin [= setting]
Zoom [= setting]

Pane (1995) Represents a pane of a window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets. The Pane object is a member of the Panes collection. The Panes collection contains all of the panes shown in a single window.

Activate()
Application
Creator
Index
LargeScroll([Down], [Up], [ToRight], [ToLeft])
Parent
ScrollColumn [= setting]
ScrollIntoView(Left, Top, Width, Height, [Start])
ScrollRow [= setting]
SmallScroll([Down], [Up], [ToRight], [ToLeft])
VisibleRange

Panes (1995) A collection of all the Pane objects shown in the specified window. Pane objects exist only for worksheets and Microsoft Excel 4.0 macro sheets.

Application
Count
Creator
Item
Parent

Parameter (1997) Represents a single parameter used in a parameter query. The Parameter object is a member of the Parameters collection.

Application
Creator
DataType [= setting]
Name [= setting]
Parent
PromptString
RefreshOnChange [= setting]
SetParam(Type, Value)
SourceRange
Type
Value

Parameters (1997) A collection of Parameter objects for the specified query table. Each Parameter object represents a single query parameter. Every query table contains a Parameters collection, but the collection is empty unless the query table is using a parameter query.

Add(Name, [iDataType])
Application
Count
Creator
Delete()
GetEnumerator()
Item(Index)
Parent

Phonetic (2000) Contains information about a specific phonetic text string in a cell. In Microsoft Excel 97, this object contained the formatting attributes for any phonetic text in the specified range.

Alignment [= setting]
Application
CharacterType [= setting]
Creator
Font
Parent
Text [= setting]
Visible [= setting]

Phonetics (2000) A collection of all the Phonetic objects in the specified range. Each Phonetic object contains information about a specific phonetic text string.

Add(Start, Length, Text)
Alignment [= setting]
Application
CharacterType [= setting]
Count
Creator
Delete()
Font
GetEnumerator()
Item
Length
Parent
Start
Text [= setting]
Visible [= setting]

PictureFormat (1997) Contains properties and methods that apply to pictures and OLE objects. The OLEFormat object contains properties and methods that apply to OLE objects whether or not theyre linked.

Application
Brightness [= setting]
ColorType [= setting]
Contrast [= setting]
Creator
CropBottom [= setting]
CropLeft [= setting]
CropRight [= setting]
CropTop [= setting]
IncrementBrightness(Increment)
IncrementContrast(Increment)
Parent
TransparencyColor [= setting]
TransparentBackground [= setting]

PivotCache (1997) Represents the memory cache for a PivotTable report. The PivotCache object is a member of the PivotCaches collection.

ADOConnection
Application
BackgroundQuery [= setting]
CommandText [= setting]
CommandType [= setting]
Connection [= setting]
CreatePivotTable(TableDestination, [TableName], [ReadData], [DefaultVersion])
Creator
EnableRefresh [= setting]
Index
IsConnected
LocalConnection [= setting]
MaintainConnection [= setting]
MakeConnection()
MemoryUsed
MissingItemsLimit [= setting]
OLAP
OptimizeCache [= setting]
Parent
QueryType
RecordCount
Recordset [= setting]
Refresh()
RefreshDate
RefreshName
RefreshOnFileOpen [= setting]
RefreshPeriod [= setting]
ResetTimer()
RobustConnect [= setting]
SaveAsODC(ODCFileName, [Description], [Keywords])
SavePassword [= setting]
SourceConnectionFile [= setting]
SourceData [= setting]
SourceDataFile
SourceType
Sql [= setting]
UseLocalConnection [= setting]

PivotCaches (1997) Represents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object.

Add(SourceType, [SourceData])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotCell (2002) Represents a cell in a PivotTable report.

Application
ColumnItems
Creator
CustomSubtotalFunction
DataField
Dummy18
Parent
PivotCellType
PivotField
PivotItem
PivotTable
Range
RowItems

PivotField (1997) Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

AddPageItem(Item, [ClearList])
Application
AutoShow(Type, Range, Count, Field)
AutoShowCount
AutoShowField
AutoShowRange
AutoShowType
AutoSort(Order, Field)
AutoSortField
AutoSortOrder
BaseField [= setting]
BaseItem [= setting]
CalculatedItems()
Calculation [= setting]
Caption [= setting]
ChildField
ChildItems
Creator
CubeField
CurrentPage [= setting]
CurrentPageList [= setting]
CurrentPageName [= setting]
DatabaseSort [= setting]
DataRange
DataType
Delete()
DragToColumn [= setting]
DragToData [= setting]
DragToHide [= setting]
DragToPage [= setting]
DragToRow [= setting]
DrilledDown [= setting]
EnableItemSelection [= setting]
Formula [= setting]
Function [= setting]
GroupLevel
HiddenItems
HiddenItemsList [= setting]
IsCalculated
IsMemberProperty
LabelRange
LayoutBlankLine [= setting]
LayoutForm [= setting]
LayoutPageBreak [= setting]
LayoutSubtotalLocation [= setting]
MemoryUsed
Name [= setting]
NumberFormat [= setting]
Orientation [= setting]
Parent
ParentField
ParentItems
PivotItems([Index])
Position [= setting]
PropertyOrder [= setting]
PropertyParentField
ServerBased [= setting]
ShowAllItems [= setting]
SourceName
StandardFormula [= setting]
SubtotalName [= setting]
Subtotals [= setting]
TotalLevels
Value [= setting]
VisibleItems

PivotFields (1997) A collection of all the PivotField objects in a PivotTable report.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotFormula (1997) Represents a formula used to calculate results in a PivotTable report.

Application
Creator
Delete()
Formula [= setting]
Index [= setting]
Parent
StandardFormula [= setting]
Value [= setting]

PivotFormulas (1997) Represents the collection of formulas for a PivotTable report. Each formula is represented by a PivotFormula object.

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

PivotItem (1995) Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField object.

Application
Caption [= setting]
ChildItems
Creator
DataRange
Delete()
DrilledDown [= setting]
Formula [= setting]
IsCalculated
LabelRange
Name [= setting]
Parent
ParentItem
ParentShowDetail
Position [= setting]
RecordCount
ShowDetail [= setting]
SourceName
SourceNameStandard
StandardFormula [= setting]
Value [= setting]
Visible [= setting]

PivotItemList (2002) A collection of all the PivotItem objects in the specified PivotTable. Each PivotItem represents an item in a PivotTable field.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotItems (1995) A collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.

Add(Name)
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PivotLayout (2000) Represents the placement of fields in a PivotChart report.

AddFields([RowFields], [ColumnFields], [PageFields], [AppendField])
Application
ColumnFields
Creator
CubeFields
DataFields
HiddenFields
InnerDetail [= setting]
PageFields
Parent
PivotCache
PivotFields
PivotTable
RowFields
VisibleFields

PivotTable (1995) Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.

AddDataField(Field, [Caption], [Function])
AddFields([RowFields], [ColumnFields], [PageFields], [AddToTable])
Application
CacheIndex [= setting]
CalculatedFields()
CalculatedMembers
ColumnFields
ColumnGrand [= setting]
ColumnRange
CreateCubeFile(File, [Measures], [Levels], [Members], [Properties])
Creator
CubeFields
DataBodyRange
DataFields
DataLabelRange
DataPivotField
DisplayEmptyColumn [= setting]
DisplayEmptyRow [= setting]
DisplayErrorString [= setting]
DisplayImmediateItems [= setting]
DisplayNullString [= setting]
Dummy15(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])
EnableDataValueEditing [= setting]
EnableDrilldown [= setting]
EnableFieldDialog [= setting]
EnableFieldList [= setting]
EnableWizard [= setting]
ErrorString [= setting]
Format(Format)
GetData(Name)
GetPivotData([DataField], [Field1], [Item1], [Field2], [Item2], [Field3], [Item3], [Field4], [Item4], [Field5], [Item5], [Field6], [Item6], [Field7], [Item7], [Field8], [Item8], [Field9], [Item9], [Field10], [Item10], [Field11], [Item11], [Field12], [Item12], [Field13], [Item13], [Field14], [Item14])
GrandTotalName [= setting]
HasAutoFormat [= setting]
HiddenFields
InnerDetail [= setting]
ListFormulas()
ManualUpdate [= setting]
MDX
MergeLabels [= setting]
Name [= setting]
NullString [= setting]
PageFieldOrder [= setting]
PageFields
PageFieldStyle [= setting]
PageFieldWrapCount [= setting]
PageRange
PageRangeCells
Parent
PivotCache()
PivotFields([Index])
PivotFormulas
PivotSelect(Name, [Mode], [UseStandardName])
PivotSelection [= setting]
PivotSelectionStandard [= setting]
PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
PreserveFormatting [= setting]
PrintTitles [= setting]
RefreshDate
RefreshName
RefreshTable()
RepeatItemsOnEachPrintedPage [= setting]
RowFields
RowGrand [= setting]
RowRange
SaveData [= setting]
SelectionMode [= setting]
ShowCellBackgroundFromOLAP [= setting]
ShowPageMultipleItemLabel [= setting]
ShowPages([PageField])
SmallGrid [= setting]
SourceData [= setting]
SubtotalHiddenPageItems [= setting]
TableRange1
TableRange2
TableStyle [= setting]
Tag [= setting]
TotalsAnnotation [= setting]
Update()
VacatedStyle [= setting]
Value [= setting]
Version
ViewCalculatedMembers [= setting]
VisibleFields
VisualTotals [= setting]

PivotTables (1995) A collection of all the PivotTable objects on the specified worksheet.

Add(PivotCache, TableDestination, [TableName], [ReadData], [DefaultVersion])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

PlotArea (1995) Represents the plot area of a chart. This is the area where your chart data is plotted. The plot area on a 2-D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls, floor, axes, axis titles, and tick-mark labels in the chart.

Application
Border
ClearFormats()
Creator
Fill
Height [= setting]
InsideHeight
InsideLeft
InsideTop
InsideWidth
Interior
Left [= setting]
Name
Parent
Select()
Top [= setting]
Width [= setting]

Point (1995) Represents a single point in a series in a chart. The Point object is a member of the Points collection. The Points collection contains all the points in one series.

Application
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
ApplyPictToEnd [= setting]
ApplyPictToFront [= setting]
ApplyPictToSides [= setting]
Border
ClearFormats()
Copy()
Creator
DataLabel
Delete()
Explosion [= setting]
Fill
HasDataLabel [= setting]
Interior
InvertIfNegative [= setting]
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Parent
Paste()
PictureType [= setting]
PictureUnit [= setting]
SecondaryPlot [= setting]
Select()
Shadow [= setting]

Points (1995) A collection of all the Point objects in the specified series in a chart.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

Protection (2002) Represents the various types of protection options available for a worksheet.

AllowDeletingColumns
AllowDeletingRows
AllowEditRanges
AllowFiltering
AllowFormattingCells
AllowFormattingColumns
AllowFormattingRows
AllowInsertingColumns
AllowInsertingHyperlinks
AllowInsertingRows
AllowSorting
AllowUsingPivotTables

PublishObject (2000) Represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the PublishObject object. The PublishObject object is a member of the PublishObjects collection.

Application
AutoRepublish [= setting]
Creator
Delete()
DivID
Filename [= setting]
HtmlType [= setting]
Parent
Publish([Create])
Sheet
Source
SourceType
Title [= setting]

PublishObjects (2000) A collection of all PublishObject objects in the workbook. Each PublishObject object represents an item in a workbook that has been saved to a Web page and can be refreshed according to values specified by the properties and methods of the object.

Add(SourceType, Filename, [Sheet], [Source], [HtmlType], [DivID], [Title])
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent
Publish()

QueryTable (1997) Represents a worksheet table built from data returned from an external data source, such as an SQL server or a Microsoft Access database. The QueryTable object is a member of the QueryTables collection.

AdjustColumnWidth [= setting]
AfterRefresh
Application
BackgroundQuery [= setting]
BeforeRefresh
CancelRefresh()
CommandText [= setting]
CommandType [= setting]
Connection [= setting]
CreateObjRef(requestedType)
Creator
Delete()
Destination
EditWebPage [= setting]
EnableEditing [= setting]
EnableRefresh [= setting]
Equals(obj)
FetchedRowOverflow
FieldNames [= setting]
FillAdjacentFormulas [= setting]
GetHashCode()
GetLifetimeService()
GetType()
HasAutoFormat [= setting]
InitializeLifetimeService()
ListObject
MaintainConnection [= setting]
Name [= setting]
Parameters
Parent
PostText [= setting]
PreserveColumnInfo [= setting]
PreserveFormatting [= setting]
QueryType
Recordset [= setting]
Refresh([BackgroundQuery])
Refreshing
RefreshOnFileOpen [= setting]
RefreshPeriod [= setting]
RefreshStyle [= setting]
ResetTimer()
ResultRange
RobustConnect [= setting]
RowNumbers [= setting]
SaveAsODC(ODCFileName, [Description], [Keywords])
SaveData [= setting]
SavePassword [= setting]
SourceConnectionFile [= setting]
SourceDataFile [= setting]
Sql [= setting]
TablesOnlyFromHTML [= setting]
TextFileColumnDataTypes [= setting]
TextFileCommaDelimiter [= setting]
TextFileConsecutiveDelimiter [= setting]
TextFileDecimalSeparator [= setting]
TextFileFixedColumnWidths [= setting]
TextFileOtherDelimiter [= setting]
TextFileParseType [= setting]
TextFilePlatform [= setting]
TextFilePromptOnRefresh [= setting]
TextFileSemicolonDelimiter [= setting]
TextFileSpaceDelimiter [= setting]
TextFileStartRow [= setting]
TextFileTabDelimiter [= setting]
TextFileTextQualifier [= setting]
TextFileThousandsSeparator [= setting]
TextFileTrailingMinusNumbers [= setting]
TextFileVisualLayout [= setting]
ToString()
WebConsecutiveDelimitersAsOne [= setting]
WebDisableDateRecognition [= setting]
WebDisableRedirections [= setting]
WebFormatting [= setting]
WebPreFormattedTextToColumns [= setting]
WebSelectionType [= setting]
WebSingleBlockTextImport [= setting]
WebTables [= setting]

QueryTables (1997) A collection of QueryTable objects. Each QueryTable object represents a worksheet table built from data returned from an external data source.

Add(Connection, Destination, [Sql])
Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

Range (1995) Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.

Activate()
AddComment([Text])
AddIndent [= setting]
Address
AddressLocal
AdvancedFilter(Action, [CriteriaRange], [CopyToRange], [Unique])
AllowEdit
Application
ApplyNames([Names], [IgnoreRelativeAbsolute], [UseRowColumnNames], [OmitColumn], [OmitRow], [Order], [AppendLast])
ApplyOutlineStyles()
Areas
AutoComplete(String)
AutoFill(Destination, [Type])
AutoFilter([Field], [Criteria1], [Operator], [Criteria2], [VisibleDropDown])
AutoFit()
AutoFormat([Format], [Number], [Font], [Alignment], [Border], [Pattern], [Width])
AutoOutline()
BorderAround([LineStyle], [Weight], [ColorIndex], [Color])
Borders
Calculate()
Cells
Characters
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
Clear()
ClearComments()
ClearContents()
ClearFormats()
ClearNotes()
ClearOutline()
Column
ColumnDifferences(Comparison)
Columns
ColumnWidth [= setting]
Comment
Consolidate([Sources], [Function], [TopRow], [LeftColumn], [CreateLinks])
Copy([Destination])
CopyFromRecordset(Data, [MaxRows], [MaxColumns])
CopyPicture([Appearance], [Format])
Count
CreateNames([Top], [Left], [Bottom], [Right])
CreatePublisher([Edition], [Appearance], [ContainsPICT], [ContainsBIFF], [ContainsRTF], [ContainsVALU])
Creator
CurrentArray
CurrentRegion
Cut([Destination])
DataSeries([Rowcol], [Type], [Date], [Step], [Stop], [Trend])
Delete([Shift])
Dependents
DialogBox()
DirectDependents
DirectPrecedents
Dirty()
EditionOptions(Type, Option, [Name], [Reference], [Appearance], [ChartSize], [Format])
End
EntireColumn
EntireRow
Errors
FillDown()
FillLeft()
FillRight()
FillUp()
Find(What, [After], [LookIn], [LookAt], [SearchOrder], [SearchDirection], [MatchCase], [MatchByte], [SearchFormat])
FindNext([After])
FindPrevious([After])
Font
FormatConditions
Formula [= setting]
FormulaArray [= setting]
FormulaHidden [= setting]
FormulaLabel [= setting]
FormulaLocal [= setting]
FormulaR1C1 [= setting]
FormulaR1C1Local [= setting]
FunctionWizard()
GetEnumerator()
GoalSeek(Goal, ChangingCell)
Group([Start], [End], [By], [Periods])
HasArray
HasFormula
Height
Hidden [= setting]
HorizontalAlignment [= setting]
Hyperlinks
ID [= setting]
IndentLevel [= setting]
Insert([Shift], [CopyOrigin])
InsertIndent(InsertAmount)
Interior
Item [= setting]
Justify()
Left
ListHeaderRows
ListNames()
ListObject
LocationInTable
Locked [= setting]
Merge([Across])
MergeArea
MergeCells [= setting]
Name [= setting]
NavigateArrow([TowardPrecedent], [ArrowNumber], [LinkNumber])
Next
NoteText([Text], [Start], [Length])
NumberFormat [= setting]
NumberFormatLocal [= setting]
Offset
Orientation [= setting]
OutlineLevel [= setting]
PageBreak [= setting]
Parent
Parse([ParseLine], [Destination])
PasteSpecial([Paste], [Operation], [SkipBlanks], [Transpose])
Phonetic
Phonetics
PivotCell
PivotField
PivotItem
PivotTable
Precedents
PrefixCharacter
Previous
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
QueryTable
Range
ReadingOrder [= setting]
RemoveSubtotal()
Replace(What, Replacement, [LookAt], [SearchOrder], [MatchCase], [MatchByte], [SearchFormat], [ReplaceFormat])
Resize
Row
RowDifferences(Comparison)
RowHeight [= setting]
Rows
Run([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])
Select()
SetPhonetic()
Show()
ShowDependents([Remove])
ShowDetail [= setting]
ShowErrors()
ShowPrecedents([Remove])
ShrinkToFit [= setting]
SmartTags
Sort([Key1], [Order1], [Key2], [Type], [Order2], [Key3], [Order3], [Header], [OrderCustom], [MatchCase], [Orientation], [SortMethod], [DataOption1], [DataOption2], [DataOption3])
SortSpecial([SortMethod], [Key1], [Order1], [Type], [Key2], [Order2], [Key3], [Order3], [Header], [OrderCustom], [MatchCase], [Orientation], [DataOption1], [DataOption2], [DataOption3])
SoundNote
Speak([SpeakDirection], [SpeakFormulas])
SpecialCells(Type, [Value])
Style [= setting]
SubscribeTo(Edition, [Format])
Subtotal(GroupBy, Function, TotalList, [Replace], [PageBreaks], [SummaryBelowData])
Summary
Table([RowInput], [ColumnInput])
Text
TextToColumns([Destination], [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers])
Top
Ungroup()
UnMerge()
UseStandardHeight [= setting]
UseStandardWidth [= setting]
Validation
Value [= setting]
Value2 [= setting]
VerticalAlignment [= setting]
Width
Worksheet
WrapText [= setting]
XPath

RecentFile (1997) Represents a file in the list of recently used files. The RecentFile object is a member of the RecentFiles collection.

Application
Creator
Delete()
Index
Name
Open()
Parent
Path

RecentFiles (1997) Represents the list of recently used files. Each file is represented by a RecentFile object.

Add(Name)
Application
Count
Creator
GetEnumerator()
Item
Maximum [= setting]
Parent

RefreshEvents (1997) Hidden or unsupported element.

AfterRefresh(Success)
BeforeRefresh(Cancel)

RoutingSlip (1995) Represents the routing slip for a workbook. The routing slip is used to send a workbook through the electronic mail system.

Application
Creator
Delivery [= setting]
Message [= setting]
Parent
Recipients [= setting]
Reset()
ReturnWhenDone [= setting]
Status
Subject [= setting]
TrackStatus [= setting]

RTD (2002) Represents a real-time data object.

RefreshData()
RestartServers()
ThrottleInterval [= setting]

Scenario (1995) Represents a scenario on a worksheet. A scenario is a group of input values (called changing cells) thats named and saved. The Scenario object is a member of the Scenarios collection. The Scenarios collection contains all the defined scenarios for a worksheet.

Application
ChangeScenario(ChangingCells, [Values])
ChangingCells
Comment [= setting]
Creator
Delete()
Hidden [= setting]
Index
Locked [= setting]
Name [= setting]
Parent
Show()
Values

Scenarios (1995) A collection of all the Scenario objects on the specified worksheet. A scenario is a group of input values (called changing cells) thats named and saved.

Add(Name, ChangingCells, [Values], [Comment], [Locked], [Hidden])
Application
Count
CreateSummary([ReportType], [ResultCells])
Creator
GetEnumerator()
Item(Index)
Merge(Source)
Parent

Series (1995) Represents a series in a chart. The Series object is a member of the SeriesCollection collection.

Application
ApplyCustomType(ChartType)
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
ApplyPictToEnd [= setting]
ApplyPictToFront [= setting]
ApplyPictToSides [= setting]
AxisGroup [= setting]
BarShape [= setting]
Border
BubbleSizes [= setting]
ChartType [= setting]
ClearFormats()
Copy()
Creator
DataLabels([Index])
Delete()
ErrorBar(Direction, Include, Type, [Amount], [MinusValues])
ErrorBars
Explosion [= setting]
Fill
Formula [= setting]
FormulaLocal [= setting]
FormulaR1C1 [= setting]
FormulaR1C1Local [= setting]
Has3DEffect [= setting]
HasDataLabels [= setting]
HasErrorBars [= setting]
HasLeaderLines [= setting]
Interior
InvertIfNegative [= setting]
LeaderLines
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Name [= setting]
Parent
Paste()
PictureType [= setting]
PictureUnit [= setting]
PlotOrder [= setting]
Points([Index])
Select()
Shadow [= setting]
Smooth [= setting]
Trendlines([Index])
Type [= setting]
Values [= setting]
XValues [= setting]

SeriesCollection (1995) A collection of all the Series objects in the specified chart or chart group.

Add(Source, [Rowcol], [SeriesLabels], [CategoryLabels], [Replace])
Application
Count
Creator
Extend(Source, [Rowcol], [CategoryLabels])
GetEnumerator()
Item(Index)
NewSeries()
Parent
Paste([Rowcol], [SeriesLabels], [CategoryLabels], [Replace], [NewSeries])

SeriesLines (1995) Represents series lines in a chart group. Series lines connect the data values from each series. Only 2-D stacked bar or column chart groups can have series lines. This object isnt a collection. Theres no object that represents a single series line; you either have series lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

ShadowFormat (1997) Represents shadow formatting for a shape.

Application
Creator
ForeColor [= setting]
IncrementOffsetX(Increment)
IncrementOffsetY(Increment)
Obscured [= setting]
OffsetX [= setting]
OffsetY [= setting]
Parent
Transparency [= setting]
Type [= setting]
Visible [= setting]

Shape (1997) Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.

Adjustments
AlternativeText [= setting]
Application
Apply()
AutoShapeType [= setting]
BlackWhiteMode [= setting]
BottomRightCell
Callout
CanvasCropBottom(Increment)
CanvasCropLeft(Increment)
CanvasCropRight(Increment)
CanvasCropTop(Increment)
CanvasItems
Child
ConnectionSiteCount
Connector
ConnectorFormat
ControlFormat
Copy()
CopyPicture([Appearance], [Format])
Creator
Cut()
Delete()
Diagram
DiagramNode
DrawingObject
Duplicate()
Fill
Flip(FlipCmd)
FormControlType
GroupItems
HasDiagram
HasDiagramNode
Height [= setting]
HorizontalFlip
Hyperlink
ID
IncrementLeft(Increment)
IncrementRotation(Increment)
IncrementTop(Increment)
Left [= setting]
Line
LinkFormat
LockAspectRatio [= setting]
Locked [= setting]
Name [= setting]
Nodes
OLEFormat
OnAction [= setting]
Parent
ParentGroup
PickUp()
PictureFormat
Placement [= setting]
RerouteConnections()
Rotation [= setting]
ScaleHeight(Factor, RelativeToOriginalSize, [Scale])
ScaleWidth(Factor, RelativeToOriginalSize, [Scale])
Script
Select([Replace])
SetShapesDefaultProperties()
Shadow
TextEffect
TextFrame
ThreeD
Top [= setting]
TopLeftCell
Type
Ungroup()
VerticalFlip
Vertices
Visible [= setting]
Width [= setting]
ZOrder(ZOrderCmd)
ZOrderPosition

ShapeNode (1997) Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform. Nodes include the vertices between the segments of the freeform and the control points for curved segments. The ShapeNode object is a member of the ShapeNodes collection. The ShapeNodes collection contains all the nodes in a freeform.

Application
Creator
EditingType
Parent
Points
SegmentType

ShapeNodes (1997) A collection of all the ConvertToShape methods.

Application
Count
Creator
Delete(Index)
GetEnumerator()
Insert(Index, SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3])
Item(Index)
Parent
SetEditingType(Index, EditingType)
SetPosition(Index, X1, Y1)
SetSegmentType(Index, SegmentType)

ShapeRange (1997) Represents a shape range, which is a set of shapes on a document. A shape range can contain as few as a single shape or as many as all the shapes on the document. You can include whichever shapes you want  chosen from among all the shapes on the document or all the shapes in the selection  to construct a shape range. For example, you could construct a ShapeRange collection that contains the first three shapes on a document, all the selected shapes on a document, or all the freeforms on a document.

Adjustments
Align(AlignCmd, RelativeTo)
AlternativeText [= setting]
Application
Apply()
AutoShapeType [= setting]
BlackWhiteMode [= setting]
Callout
CanvasCropBottom(Increment)
CanvasCropLeft(Increment)
CanvasCropRight(Increment)
CanvasCropTop(Increment)
CanvasItems
Child
ConnectionSiteCount
Connector
ConnectorFormat
Count
Creator
Delete()
Diagram
DiagramNode
Distribute(DistributeCmd, RelativeTo)
Duplicate()
Fill
Flip(FlipCmd)
GetEnumerator()
Group()
GroupItems
HasDiagram
HasDiagramNode
Height [= setting]
HorizontalFlip
ID
IncrementLeft(Increment)
IncrementRotation(Increment)
IncrementTop(Increment)
Item(Index)
Left [= setting]
Line
LockAspectRatio [= setting]
Name [= setting]
Nodes
Parent
ParentGroup
PickUp()
PictureFormat
Regroup()
RerouteConnections()
Rotation [= setting]
ScaleHeight(Factor, RelativeToOriginalSize, [Scale])
ScaleWidth(Factor, RelativeToOriginalSize, [Scale])
Select([Replace])
SetShapesDefaultProperties()
Shadow
TextEffect
TextFrame
ThreeD
Top [= setting]
Type
Ungroup()
VerticalFlip
Vertices
Visible [= setting]
Width [= setting]
ZOrder(ZOrderCmd)
ZOrderPosition

Shapes (1997) A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.

AddCallout(Type, Left, Top, Width, Height)
AddCanvas(Left, Top, Width, Height)
AddConnector(Type, BeginX, BeginY, EndX, EndY)
AddCurve(SafeArrayOfPoints)
AddDiagram(Type, Left, Top, Width, Height)
AddFormControl(Type, Left, Top, Width, Height)
AddLabel(Orientation, Left, Top, Width, Height)
AddLine(BeginX, BeginY, EndX, EndY)
AddOLEObject([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])
AddPicture(Filename, LinkToFile, SaveWithDocument, Left, Top, Width, Height)
AddPolyline(SafeArrayOfPoints)
AddShape(Type, Left, Top, Width, Height)
AddTextbox(Orientation, Left, Top, Width, Height)
AddTextEffect(PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top)
Application
BuildFreeform(EditingType, X1, Y1)
Count
Creator
GetEnumerator()
Item(Index)
Parent
Range
SelectAll()

Sheets (1995) A collection of all the sheets in the specified or active workbook. The Sheets collection can contain Worksheet objects.

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

SmartTag (2002) Represents an identifier that is assigned to a cell.

Application
Creator
Delete()
DownloadURL
Name
Parent
Properties
Range
SmartTagActions
XML

SmartTagAction (2002) Represents the actions that can be performed with smart tags.

ActiveXControl
Application
CheckboxState [= setting]
Creator
Execute()
ExpandHelp [= setting]
ListSelection [= setting]
Name
Parent
PresentInPane
RadioGroupSelection [= setting]
TextboxText [= setting]
Type

SmartTagActions (2002) A collection of SmartTagAction objects that represent the actions that can be performed with smart tags.

Application
Count
Creator
GetEnumerator()
Item
Parent

SmartTagOptions (2002) Represents the options that can be performed with smart tags.

Application
Creator
DisplaySmartTags [= setting]
EmbedSmartTags [= setting]
Parent

SmartTagRecognizer (2002) Represents recognition engines which label data with types of information as you work in Microsoft Excel.

Application
Creator
Enabled [= setting]
FullName
Parent
progID

SmartTagRecognizers (2002) A collection of SmartTagRecognizer objects that represent recognition engines which label data with types of information as you work in Microsoft Excel.

Application
Count
Creator
GetEnumerator()
Item
Parent
Recognize [= setting]

SmartTags (2002) A collection of SmartTag objects that represent the identifiers assigned to each cell.

Add(SmartTagType)
Application
Count
Creator
GetEnumerator()
Parent

Speech (2002) Hidden or unsupported element.

Direction [= setting]
Speak(Text, [SpeakAsync], [SpeakXML], [Purge])
SpeakCellOnEnter [= setting]

SpellingOptions (2002) Represents the various spell checking options for a worksheet.

ArabicModes [= setting]
DictLang [= setting]
GermanPostReform [= setting]
HebrewModes [= setting]
IgnoreCaps [= setting]
IgnoreFileNames [= setting]
IgnoreMixedDigits [= setting]
KoreanCombineAux [= setting]
KoreanProcessCompound [= setting]
KoreanUseAutoChangeList [= setting]
SuggestMainOnly [= setting]
UserDict [= setting]

Style (1995) Represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles, including Normal, Currency, and Percent. Using the Style object is a fast and efficient way to change several cell-formatting properties on multiple cells at the same time.

AddIndent [= setting]
Application
Borders
BuiltIn
Creator
Delete()
Font
FormulaHidden [= setting]
HorizontalAlignment [= setting]
IncludeAlignment [= setting]
IncludeBorder [= setting]
IncludeFont [= setting]
IncludeNumber [= setting]
IncludePatterns [= setting]
IncludeProtection [= setting]
IndentLevel [= setting]
Interior
Locked [= setting]
MergeCells [= setting]
Name
NameLocal
NumberFormat [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
ShrinkToFit [= setting]
Value
VerticalAlignment [= setting]
WrapText [= setting]

Styles (1995) A collection of all the Style objects in the specified or active workbook. Each Style object represents a style description for a range. The Style object contains all style attributes (font, number format, alignment, and so on) as properties. There are several built-in styles  including Normal, Currency, and Percent  which are listed in the Style name box in the Style dialog box (Format menu).

Add(Name, [BasedOn])
Application
Count
Creator
GetEnumerator()
Item
Merge(Workbook)
Parent

Tab (2002) Represents a tab in a chart or a worksheet.

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

TextEffectFormat (1997) Contains properties and methods that apply to WordArt objects.

Alignment [= setting]
Application
Creator
FontBold [= setting]
FontItalic [= setting]
FontName [= setting]
FontSize [= setting]
KernedPairs [= setting]
NormalizedHeight [= setting]
Parent
PresetShape [= setting]
PresetTextEffect [= setting]
RotatedChars [= setting]
Text [= setting]
ToggleVerticalText()
Tracking [= setting]

TextFrame (1997) Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.

Application
AutoMargins [= setting]
AutoSize [= setting]
Characters([Start], [Length])
Creator
HorizontalAlignment [= setting]
MarginBottom [= setting]
MarginLeft [= setting]
MarginRight [= setting]
MarginTop [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
VerticalAlignment [= setting]

ThreeDFormat (1997) Represents three-dimensional formatting of a shape.

Application
Creator
Depth [= setting]
ExtrusionColor
ExtrusionColorType [= setting]
IncrementRotationX(Increment)
IncrementRotationY(Increment)
Parent
Perspective [= setting]
PresetExtrusionDirection
PresetLightingDirection [= setting]
PresetLightingSoftness [= setting]
PresetMaterial [= setting]
PresetThreeDFormat
ResetRotation()
RotationX [= setting]
RotationY [= setting]
SetExtrusionDirection(PresetExtrusionDirection)
SetThreeDFormat(PresetThreeDFormat)
Visible [= setting]

TickLabels (1995) Represents the tick-mark labels associated with tick marks on a chart axis. This object isnt a collection. Theres no object that represents a single tick-mark label; you must return all the tick-mark labels as a unit.

Alignment [= setting]
Application
AutoScaleFont [= setting]
Creator
Delete()
Depth
Font
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Offset [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()

Trendline (1995) Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. The Trendline object is a member of the Trendlines collection. The Trendlines collection contains all the Trendline objects for a single series.

Application
Backward [= setting]
Border
ClearFormats()
Creator
DataLabel
Delete()
DisplayEquation [= setting]
DisplayRSquared [= setting]
Forward [= setting]
Index
Intercept [= setting]
InterceptIsAuto [= setting]
Name [= setting]
NameIsAuto [= setting]
Order [= setting]
Parent
Period [= setting]
Select()
Type [= setting]

Trendlines (1995) A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

Add([Type], [Order], [Period], [Forward], [Backward], [Intercept], [DisplayEquation], [DisplayRSquared], [Name])
Application
Count
Creator
GetEnumerator()
Item([Index])
Parent

UpBars (1995) Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2-D line groups that contain at least two series can have up bars. This object isnt a collection. Theres no object that represents a single up bar; you either have up 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()

UsedObjects (2002) Represents objects that have been allocated in a workbook.

Application
Count
Creator
GetEnumerator()
Item
Parent

UserAccess (2002) Represents the user access for a protected range.

AllowEdit [= setting]
Delete()
Name

UserAccessList (2002) A collection of UserAccess objects that represent the user access for protected ranges.

Add(Name, AllowEdit)
Count
DeleteAll()
GetEnumerator()
Item

Validation (1997) Represents data validation for a worksheet range.

Add(Type, [AlertStyle], [Operator], [Formula1], [Formula2])
AlertStyle
Application
Creator
Delete()
ErrorMessage [= setting]
ErrorTitle [= setting]
Formula1
Formula2
IgnoreBlank [= setting]
IMEMode [= setting]
InCellDropdown [= setting]
InputMessage [= setting]
InputTitle [= setting]
Modify([Type], [AlertStyle], [Operator], [Formula1], [Formula2])
Operator
Parent
ShowError [= setting]
ShowInput [= setting]
Type
Value

VPageBreak (1997) Represents a vertical page break. The VPageBreak object is a member of the VPageBreaks collection.

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

VPageBreaks (1997) A collection of vertical page breaks within the print area. Each vertical page break is represented by a VPageBreak object.

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

Walls (1995) Represents the walls of a 3-D chart. This object isnt a collection. Theres no object that represents a single wall; you must return all the walls as a unit.

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

Watch (2002) Represents a range which is tracked when the worksheet is recalculated. The Watch object allows users to verify the accuracy of their models and debug problems they encounter. The Watch object is a member of the Watches collection.

Application
Creator
Delete()
Parent
Source

Watches (2002) A collection of all the Watch objects in a specified application.

Add(Source)
Application
Count
Creator
Delete()
GetEnumerator()
Item
Parent

WebOptions (2000) Contains workbook-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. Application-level attributes are contained in the DefaultWebOptions object.

AllowPNG [= setting]
Application
Creator
DownloadComponents [= setting]
Encoding [= setting]
FolderSuffix
LocationOfComponents [= setting]
OrganizeInFolder [= setting]
Parent
PixelsPerInch [= setting]
RelyOnCSS [= setting]
RelyOnVML [= setting]
ScreenSize [= setting]
TargetBrowser [= setting]
UseDefaultFolderSuffix()
UseLongFileNames [= setting]

Window (1995) Represents a window. Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. The Window object is a member of the Windows collection. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.

Activate()
ActivateNext()
ActivatePrevious()
ActiveCell
ActiveChart
ActivePane
ActiveSheet
Application
Caption [= setting]
Close([SaveChanges], [Filename], [RouteWorkbook])
Creator
DisplayFormulas [= setting]
DisplayGridlines [= setting]
DisplayHeadings [= setting]
DisplayHorizontalScrollBar [= setting]
DisplayOutline [= setting]
DisplayRightToLeft [= setting]
DisplayVerticalScrollBar [= setting]
DisplayWorkbookTabs [= setting]
DisplayZeros [= setting]
EnableResize [= setting]
FreezePanes [= setting]
GridlineColor [= setting]
GridlineColorIndex [= setting]
Height [= setting]
Index
LargeScroll([Down], [Up], [ToRight], [ToLeft])
Left [= setting]
NewWindow()
OnWindow [= setting]
Panes
Parent
PointsToScreenPixelsX(Points)
PointsToScreenPixelsY(Points)
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
RangeFromPoint(x, y)
RangeSelection
ScrollColumn [= setting]
ScrollIntoView(Left, Top, Width, Height, [Start])
ScrollRow [= setting]
ScrollWorkbookTabs([Sheets], [Position])
SelectedSheets
Selection
SmallScroll([Down], [Up], [ToRight], [ToLeft])
Split [= setting]
SplitColumn [= setting]
SplitHorizontal [= setting]
SplitRow [= setting]
SplitVertical [= setting]
TabRatio [= setting]
Top [= setting]
Type
UsableHeight
UsableWidth
View [= setting]
Visible [= setting]
VisibleRange
Width [= setting]
WindowNumber
WindowState [= setting]
Zoom [= setting]

Windows (1995) A collection of all the Window objects in Microsoft Excel. The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.

Application
Arrange([ArrangeStyle], [ActiveWorkbook], [SyncHorizontal], [SyncVertical])
BreakSideBySide()
CompareSideBySideWith(WindowName)
Count
Creator
GetEnumerator()
Item
Parent
ResetPositionsSideBySide()
SyncScrollingSideBySide [= setting]

Workbook (1995) Represents a Microsoft Excel workbook. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel.

AcceptAllChanges([When], [Who], [Where])
AcceptLabelsInFormulas [= setting]
Activate()
ActiveChart
ActiveSheet
AddinInstall
AddinUninstall
AddToFavorites()
AfterXmlExport
AfterXmlImport
Application
Author [= setting]
AutoUpdateFrequency [= setting]
AutoUpdateSaveChanges [= setting]
BeforeClose
BeforePrint
BeforeSave
BeforeXmlExport
BeforeXmlImport
BreakLink(Name, Type)
BuiltinDocumentProperties
CalculationVersion
CanCheckIn()
ChangeFileAccess(Mode, [WritePassword], [Notify])
ChangeHistoryDuration [= setting]
ChangeLink(Name, NewName, [Type])
Charts
CheckIn([SaveChanges], [Comments], [MakePublic])
Close([SaveChanges], [Filename], [RouteWorkbook])
CodeName
Colors [= setting]
CommandBars
Comments [= setting]
ConflictResolution [= setting]
Container
CreateBackup
CreateObjRef(requestedType)
Creator
CustomDocumentProperties
CustomViews
Date1904 [= setting]
Deactivate
DeleteNumberFormat(NumberFormat)
DialogSheets
DisplayDrawingObjects [= setting]
DisplayInkComments [= setting]
DocumentLibraryVersions
Dummy16()
Dummy17(calcid)
EnableAutoRecover [= setting]
EndReview()
EnvelopeVisible [= setting]
Equals(obj)
Excel4IntlMacroSheets
Excel4MacroSheets
ExclusiveAccess()
FileFormat
FollowHyperlink(Address, [SubAddress], [NewWindow], [AddHistory], [ExtraInfo], [Method], [HeaderInfo])
ForwardMailer()
FullName
FullNameURLEncoded
GetHashCode()
GetLifetimeService()
GetType()
HasMailer [= setting]
HasPassword
HasRoutingSlip [= setting]
HighlightChangesOnScreen [= setting]
HighlightChangesOptions([When], [Who], [Where])
HTMLProject
InactiveListBorderVisible [= setting]
InitializeLifetimeService()
IsAddin [= setting]
IsInplace
KeepChangeHistory [= setting]
Keywords [= setting]
LinkInfo(Name, LinkInfo, [Type], [EditionRef])
LinkSources([Type])
ListChangesOnNewSheet [= setting]
Mailer
MergeWorkbook(Filename)
Modules
MultiUserEditing
Name
Names
NewSheet
NewWindow()
OnSave [= setting]
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
Open
OpenLinks(Name, [ReadOnly], [Type])
Parent
Password [= setting]
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
Path
Permission
PersonalViewListSettings [= setting]
PersonalViewPrintSettings [= setting]
PivotCaches()
PivotTableCloseConnection
PivotTableOpenConnection
PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
Post([DestName])
PrecisionAsDisplayed [= setting]
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Protect([Password], [Structure], [Windows])
ProtectSharing([Filename], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [SharingPassword])
ProtectStructure
ProtectWindows
PublishObjects
PurgeChangeHistoryNow(Days, [SharingPassword])
ReadOnly
ReadOnlyRecommended [= setting]
RecheckSmartTags()
RefreshAll()
RejectAllChanges([When], [Who], [Where])
ReloadAs(Encoding)
RemovePersonalInformation [= setting]
RemoveUser(Index)
Reply()
ReplyAll()
ReplyWithChanges([ShowMessage])
ResetColors()
RevisionNumber
Route()
Routed
RoutingSlip
RunAutoMacros(Which)
Save()
SaveAs([Filename], [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AccessMode], [ConflictResolution], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
SaveAsXMLData(Filename, Map)
SaveCopyAs([Filename])
Saved [= setting]
SaveLinkValues [= setting]
sblt(s)
SendFaxOverInternet([Recipients], [Subject], [ShowMessage])
SendForReview([Recipients], [Subject], [ShowMessage], [IncludeAttachment])
SendMail(Recipients, [Subject], [ReturnReceipt])
SendMailer([FileFormat], [Priority])
SetLinkOnData(Name, [Procedure])
SetPasswordEncryptionOptions([PasswordEncryptionProvider], [PasswordEncryptionAlgorithm], [PasswordEncryptionKeyLength], [PasswordEncryptionFileProperties])
SharedWorkspace
SheetActivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetCalculate
SheetChange
SheetDeactivate
SheetFollowHyperlink
SheetPivotTableUpdate
Sheets
SheetSelectionChange
ShowConflictHistory [= setting]
ShowPivotTableFieldList [= setting]
SmartDocument
SmartTagOptions
Styles
Subject [= setting]
Sync
TemplateRemoveExtData [= setting]
Title [= setting]
ToggleFormsDesign()
ToString()
Unprotect([Password])
UnprotectSharing([SharingPassword])
UpdateFromFile()
UpdateLink([Name], [Type])
UpdateLinks [= setting]
UpdateRemoteReferences [= setting]
UserControl [= setting]
UserStatus
VBASigned
VBProject
WebOptions
WebPagePreview()
WindowActivate
WindowDeactivate
WindowResize
Windows
WorkbookEvents_Event_Activate
WorkbookEvents_Event_Sync
Worksheets
WritePassword [= setting]
WriteReserved
WriteReservedBy
XmlImport(Url, ImportMap, [Overwrite], [Destination])
XmlImportXml(Data, ImportMap, [Overwrite], [Destination])
XmlMaps
XmlNamespaces

WorkbookEvents (1997) Hidden or unsupported element.

Activate()
AddinInstall()
AddinUninstall()
AfterXmlExport(Map, Url, Result)
AfterXmlImport(Map, IsRefresh, Result)
BeforeClose(Cancel)
BeforePrint(Cancel)
BeforeSave(SaveAsUI, Cancel)
BeforeXmlExport(Map, Url, Cancel)
BeforeXmlImport(Map, Url, IsRefresh, Cancel)
Deactivate()
NewSheet(Sh)
Open()
PivotTableCloseConnection(Target)
PivotTableOpenConnection(Target)
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)
Sync(SyncEventType)
WindowActivate(Wn)
WindowDeactivate(Wn)
WindowResize(Wn)

Workbooks (1995) A collection of all the Workbook objects that are currently open in the Microsoft Excel application.

Add([Template])
Application
CanCheckOut(Filename)
CheckOut(Filename)
Close()
Count
Creator
GetEnumerator()
Item
Open(Filename, [UpdateLinks], [ReadOnly], [Format], [Password], [WriteResPassword], [IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru], [Local], [CorruptLoad])
OpenDatabase(Filename, [CommandText], [CommandType], [BackgroundQuery], [ImportDataAs])
OpenText(Filename, [Origin], [StartRow], [DataType], [TextQualifier], [ConsecutiveDelimiter], [Tab], [Semicolon], [Comma], [Space], [Other], [OtherChar], [FieldInfo], [TextVisualLayout], [DecimalSeparator], [ThousandsSeparator], [TrailingMinusNumbers], [Local])
OpenXML(Filename, [Stylesheets], [LoadOption])
Parent

Worksheet (1995) Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook.

Activate()
Application
Arcs([Index])
AutoFilter
AutoFilterMode [= setting]
BeforeDoubleClick
BeforeRightClick
Buttons([Index])
Calculate()
Cells
Change
ChartObjects([Index])
CheckBoxes([Index])
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
CircleInvalid()
CircularReference
ClearArrows()
ClearCircles()
CodeName
Columns
Comments
ConsolidationFunction
ConsolidationOptions
ConsolidationSources
Copy([Before], [After])
CreateObjRef(requestedType)
Creator
CustomProperties
Deactivate
Delete()
DisplayAutomaticPageBreaks [= setting]
DisplayPageBreaks [= setting]
DisplayRightToLeft [= setting]
DocEvents_Event_Activate
DocEvents_Event_Calculate
DrawingObjects([Index])
Drawings([Index])
DropDowns([Index])
EnableAutoFilter [= setting]
EnableCalculation [= setting]
EnableOutlining [= setting]
EnablePivotTable [= setting]
EnableSelection [= setting]
Equals(obj)
Evaluate(Name)
FilterMode
FollowHyperlink
GetHashCode()
GetLifetimeService()
GetType()
GroupBoxes([Index])
GroupObjects([Index])
HPageBreaks
Hyperlinks
Index
InitializeLifetimeService()
Labels([Index])
Lines([Index])
ListBoxes([Index])
ListObjects
MailEnvelope
Move([Before], [After])
Name [= setting]
Names
Next
OLEObjects([Index])
OnCalculate [= setting]
OnData [= setting]
OnDoubleClick [= setting]
OnEntry [= setting]
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
OptionButtons([Index])
Outline
Ovals([Index])
PageSetup
Parent
Paste([Destination], [Link])
PasteSpecial([Format], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [NoHTMLFormatting])
Pictures([Index])
PivotTables([Index])
PivotTableUpdate
PivotTableWizard([SourceType], [SourceData], [TableDestination], [TableName], [RowGrand], [ColumnGrand], [SaveData], [HasAutoFormat], [AutoPage], [Reserved], [BackgroundQuery], [OptimizeCache], [PageFieldOrder], [PageFieldWrapCount], [ReadData], [Connection])
Previous
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly], [AllowFormattingCells], [AllowFormattingColumns], [AllowFormattingRows], [AllowInsertingColumns], [AllowInsertingRows], [AllowInsertingHyperlinks], [AllowDeletingColumns], [AllowDeletingRows], [AllowSorting], [AllowFiltering], [AllowUsingPivotTables])
ProtectContents
ProtectDrawingObjects
Protection
ProtectionMode
ProtectScenarios
QueryTables
Range
Rectangles([Index])
ResetAllPageBreaks()
Rows
SaveAs(Filename, [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
Scenarios([Index])
Scripts
ScrollArea [= setting]
ScrollBars([Index])
Select([Replace])
SelectionChange
SetBackgroundPicture(Filename)
Shapes
ShowAllData()
ShowDataForm()
SmartTags
Spinners([Index])
StandardHeight
StandardWidth [= setting]
Tab
TextBoxes([Index])
ToString()
TransitionExpEval [= setting]
TransitionFormEntry [= setting]
Type
Unprotect([Password])
UsedRange
Visible [= setting]
VPageBreaks
XmlDataQuery(XPath, [SelectionNamespaces], [Map])
XmlMapQuery(XPath, [SelectionNamespaces], [Map])

WorksheetFunction (1995) Used as a container for Microsoft Excel worksheet functions that can be called from Visual Basic.

Acos(Arg1)
Acosh(Arg1)
And(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])
Application
Asc(Arg1)
Asin(Arg1)
Asinh(Arg1)
Atan2(Arg1, Arg2)
Atanh(Arg1)
AveDev(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])
Average(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])
BahtText(Arg1)
BetaDist(Arg1, Arg2, Arg3, [Arg4], [Arg5])
BetaInv(Arg1, Arg2, Arg3, [Arg4], [Arg5])
BinomDist(Arg1, Arg2, Arg3, Arg4)
Ceiling(Arg1, Arg2)
ChiDist(Arg1, Arg2)
ChiInv(Arg1, Arg2)
ChiTest(Arg1, Arg2)
Choose(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])
Clean(Arg1)
Combin(Arg1, Arg2)
Confidence(Arg1, Arg2, Arg3)
Correl(Arg1, Arg2)
Cosh(Arg1)
Count(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])
CountA(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])
CountBlank(Arg1)
CountIf(Arg1, Arg2)
Covar(Arg1, Arg2)
Creator
CritBinom(Arg1, Arg2, Arg3)
DAverage(Arg1, Arg2, Arg3)
Days360(Arg1, Arg2, [Arg3])
Db(Arg1, Arg2, Arg3, Arg4, [Arg5])
Dbcs(Arg1)
DCount(Arg1, Arg2, Arg3)
DCountA(Arg1, Arg2, Arg3)
Ddb(Arg1, Arg2, Arg3, Arg4, [Arg5])
Degrees(Arg1)
DevSq(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])
DGet(Arg1, Arg2, Arg3)
DMax(Arg1, Arg2, Arg3)
DMin(Arg1, Arg2, Arg3)
Dollar(Arg1, [Arg2])
DProduct(Arg1, Arg2, Arg3)
DStDev(Arg1, Arg2, Arg3)
DStDevP(Arg1, Arg2, Arg3)
DSum(Arg1, Arg2, Arg3)
DVar(Arg1, Arg2, Arg3)
DVarP(Arg1, Arg2, Arg3)
Even(Arg1)
ExponDist(Arg1, Arg2, Arg3)
Fact(Arg1)
FDist(Arg1, Arg2, Arg3)
Find(Arg1, Arg2, [Arg3])
FindB(Arg1, Arg2, [Arg3])
FInv(Arg1, Arg2, Arg3)
Fisher(Arg1)
FisherInv(Arg1)
Fixed(Arg1, [Arg2], [Arg3])
Floor(Arg1, Arg2)
Forecast(Arg1, Arg2, Arg3)
Frequency(Arg1, Arg2)
FTest(Arg1, Arg2)
Fv(Arg1, Arg2, Arg3, [Arg4], [Arg5])
GammaDist(Arg1, Arg2, Arg3, Arg4)
GammaInv(Arg1, Arg2, Arg3)
GammaLn(Arg1)
GeoMean(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])
Growth(Arg1, [Arg2], [Arg3], [Arg4])
HarMean(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])
HLookup(Arg1, Arg2, Arg3, [Arg4])
HypGeomDist(Arg1, Arg2, Arg3, Arg4)
Index(Arg1, Arg2, [Arg3], [Arg4])
Intercept(Arg1, Arg2)
Ipmt(Arg1, Arg2, Arg3, Arg4, [Arg5], [Arg6])
Irr(Arg1, [Arg2])
IsErr(Arg1)
IsError(Arg1)
IsLogical(Arg1)
IsNA(Arg1)
IsNonText(Arg1)
IsNumber(Arg1)
Ispmt(Arg1, Arg2, Arg3, Arg4)
IsText(Arg1)
IsThaiDigit(Arg1)
Kurt(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])
Large(Arg1, Arg2)
LinEst(Arg1, [Arg2], [Arg3], [Arg4])
Ln(Arg1)
Log(Arg1, [Arg2])
Log10(Arg1)
LogEst(Arg1, [Arg2], [Arg3], [Arg4])
LogInv(Arg1, Arg2, Arg3)
LogNormDist(Arg1, Arg2, Arg3)
Lookup(Arg1, Arg2, [Arg3])
Match(Arg1, Arg2, [Arg3])
Max(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])
MDeterm(Arg1)
Median(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])
Min(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])
MInverse(Arg1)
MIrr(Arg1, Arg2, Arg3)
MMult(Arg1, Arg2)
Mode(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])
NegBinomDist(Arg1, Arg2, Arg3)
NormDist(Arg1, Arg2, Arg3, Arg4)
NormInv(Arg1, Arg2, Arg3)
NormSDist(Arg1)
NormSInv(Arg1)
NPer(Arg1, Arg2, Arg3, [Arg4], [Arg5])
Npv(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])
Odd(Arg1)
Or(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])
Parent
Pearson(Arg1, Arg2)
Percentile(Arg1, Arg2)
PercentRank(Arg1, Arg2, [Arg3])
Permut(Arg1, Arg2)
Phonetic(Arg1)
Pi()
Pmt(Arg1, Arg2, Arg3, [Arg4], [Arg5])
Poisson(Arg1, Arg2, Arg3)
Power(Arg1, Arg2)
Ppmt(Arg1, Arg2, Arg3, Arg4, [Arg5], [Arg6])
Prob(Arg1, Arg2, Arg3, [Arg4])
Product(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])
Proper(Arg1)
Pv(Arg1, Arg2, Arg3, [Arg4], [Arg5])
Quartile(Arg1, Arg2)
Radians(Arg1)
Rank(Arg1, Arg2, [Arg3])
Rate(Arg1, Arg2, Arg3, [Arg4], [Arg5], [Arg6])
Replace(Arg1, Arg2, Arg3, Arg4)
ReplaceB(Arg1, Arg2, Arg3, Arg4)
Rept(Arg1, Arg2)
Roman(Arg1, [Arg2])
Round(Arg1, Arg2)
RoundBahtDown(Arg1)
RoundBahtUp(Arg1)
RoundDown(Arg1, Arg2)
RoundUp(Arg1, Arg2)
RSq(Arg1, Arg2)
RTD(progID, server, topic1, [topic2], [topic3], [topic4], [topic5], [topic6], [topic7], [topic8], [topic9], [topic10], [topic11], [topic12], [topic13], [topic14], [topic15], [topic16], [topic17], [topic18], [topic19], [topic20], [topic21], [topic22], [topic23], [topic24], [topic25], [topic26], [topic27], [topic28])
Search(Arg1, Arg2, [Arg3])
SearchB(Arg1, Arg2, [Arg3])
Sinh(Arg1)
Skew(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])
Sln(Arg1, Arg2, Arg3)
Slope(Arg1, Arg2)
Small(Arg1, Arg2)
Standardize(Arg1, Arg2, Arg3)
StDev(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])
StDevP(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])
StEyx(Arg1, Arg2)
Substitute(Arg1, Arg2, Arg3, [Arg4])
Subtotal(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])
Sum(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])
SumIf(Arg1, Arg2, [Arg3])
SumProduct(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])
SumSq(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])
SumX2MY2(Arg1, Arg2)
SumX2PY2(Arg1, Arg2)
SumXMY2(Arg1, Arg2)
Syd(Arg1, Arg2, Arg3, Arg4)
Tanh(Arg1)
TDist(Arg1, Arg2, Arg3)
Text(Arg1, Arg2)
ThaiDayOfWeek(Arg1)
ThaiDigit(Arg1)
ThaiMonthOfYear(Arg1)
ThaiNumSound(Arg1)
ThaiNumString(Arg1)
ThaiStringLength(Arg1)
ThaiYear(Arg1)
TInv(Arg1, Arg2)
Transpose(Arg1)
Trend(Arg1, [Arg2], [Arg3], [Arg4])
Trim(Arg1)
TrimMean(Arg1, Arg2)
TTest(Arg1, Arg2, Arg3, Arg4)
USDollar(Arg1, Arg2)
Var(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])
VarP(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])
Vdb(Arg1, Arg2, Arg3, Arg4, Arg5, [Arg6], [Arg7])
VLookup(Arg1, Arg2, Arg3, [Arg4])
Weekday(Arg1, [Arg2])
Weibull(Arg1, Arg2, Arg3, Arg4)
ZTest(Arg1, Arg2, [Arg3])

Worksheets (1995) A collection of all the Worksheet objects in the specified or active workbook. Each Worksheet object represents a worksheet.

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

XmlDataBinding (2003) Represents the connection to the source data for an XmlMap object.

Application
ClearSettings()
Creator
LoadSettings(Url)
Parent
Refresh()
SourceUrl

XmlMap (2003) Represents an XML map that has been added to a workbook.

AdjustColumnWidth [= setting]
AppendOnImport [= setting]
Application
Creator
DataBinding
Delete()
Export(Url, [Overwrite])
ExportXml(Data)
Import(Url, [Overwrite])
ImportXml(XmlData, [Overwrite])
IsExportable
Name [= setting]
Parent
PreserveColumnFilter [= setting]
PreserveNumberFormatting [= setting]
RootElementName
RootElementNamespace
SaveDataSourceDefinition [= setting]
Schemas
ShowImportExportValidationErrors [= setting]

XmlMaps (2003) Represents the collection of XmlMap objects that have been added to a workbook.

Add(Schema, [RootElementName])
Application
Count
Creator
GetEnumerator()
Item
Parent

XmlNamespace (2003) Represents a namespace that has been added to a workbook.

Application
Creator
Parent
Prefix
Uri

XmlNamespaces (2003) Represents the collection of XmlNamespace objects in a workbook.

Application
Count
Creator
GetEnumerator()
InstallManifest(Path, [InstallForAllUsers])
Item
Parent
Value

XmlSchema (2003) Represents an XML schema contained by an XmlMap object.

Application
Creator
Name
Namespace
Parent
XML

XmlSchemas (2003) Represents the collection of XmlMap object.

Application
Count
Creator
GetEnumerator()
Item
Parent

XPath (2003) Represents an XPath that has been mapped to a ListColumn object.

Application
Clear()
Creator
Map
Parent
Repeating
SetValue(Map, XPath, [SelectionNamespace], [Repeating])
Value