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