Chapter The Range Object

The Range object is one of the workhorse objects in the Excel object model. Simply put, to work with a portion of an Excel worksheet, we generally need to first identify that portion as a Range object.

As Microsoft puts it, a Range object "Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range."

Table 19-1 shows the 158 members of the Range object.

Table 19-1. Members of the Range Object

_Default

End

Phonetic

_NewEnum

EntireColumn

Phonetics<v9>

_PasteSpecial<v10>

EntireRow

PivotCell<v10>

_PrintOut<v9>

Errors<v10>

PivotField

Activate

FillDown

Pivotltem

AddComment

FillLeft

PivotTable

Addlndent

FillRight

Precedents

Address

FillUp

PrefixCharacter

AddressLocal

Find

Previous

AdvancedFilter

FindNext

PrintOut

AllowEdit<v10>

FindPrevious

PrintPreview

Application

Font

QueryTable

ApplyNames

FormatConditions

Range

ApplyOutline Styles

Formula

ReadingOrder

Areas

FormulaArray

Remove Subtotal

AutoComplete

FormulaHidden

Replace

AutoFill

FormulaLabel

Resize

AutoFilter

FormulaLocal

Row

AutoFit

FormulaR1C1

RowDifferences

AutoFormat

FormulaR1 C1 Local

RowHeight

AutoOutline

Function Wizard

Rows

BorderAround

GoalSeek

Run

Borders

Group

Select

Calculate

Has Array

SetPhonetic<v9>

Cells

HasFormula

Show

Characters

Height

ShowDependents

CheckSpelling

Hidden

ShowDetail

Clear

HorizontalAlignment

ShowErrors

ClearComments

Hyperlinks

ShowPrecedents

ClearContents

ID<v9>

ShrinkToFit

ClearFormats

IndentLevel

SmartTags<v10>

ClearNotes

Insert

Sort

ClearOutline

Insertlndent

SortSpecial

Column

Interior

SoundNote

ColumnDifferences

Item

Speak<v10>

Columns

Justify

SpecialCells

Column Width

Left

Style

Comment

ListHeaderRows

SubscribeTo

Consolidate

ListNames

Subtotal

Copy

LocationlnTable

Summary

CopyFromRecordset

Locked

Table

CopyPicture

Merge

Text

Count

MergeArea

TextToColumns

CreateNames

MergeCells

Top

CreatePublisher

Name

Ungroup

Creator

Navigate Arrow

UnMerge

CurrentArray

Next

Use StandardHeight

CurrentRegion

NoteText

Use StandardWidth

Cut

NumberFormat

Validation

DataSeries

NumberFormatLocal

Value

Delete

Offset

Value2

Dependents

Orientation

VerticalAlignment

DialogBox

OutlineLevel

Width

DirectDependents

PageBreak

Worksheet

DirectPrecedents

Parent

WrapText

Dirty<v10>

Parse

EditionOptions

PasteSpecial

Our plan in this chapter is first to explore ways of defining Range objects. Then we will discuss many of the properties and methods of this object, as indicated in Table 19-1. As we have mentioned, our goal is not to cover all aspects of the Excel object model, but to cover the main portions of the model and to provide you with a sufficient foundation so that you can pick up whatever else you may need by using the help system.

0 0

Post a comment