Excel Range Objects

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

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

AutoFilter (1995) Represents autofiltering for the specified worksheet.

Application
Creator
Filters
Parent
Range

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]

DocEvents (1997) Hidden or unsupported element.

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

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

Application
Creator
Ignore [= setting]
Parent
Value

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

Application
Creator
Item
Parent

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

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

Outline (1995) Represents an outline on a worksheet.

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

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]

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

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

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

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

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

Application
Color [= setting]
ColorIndex [= setting]
Creator
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

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

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