O'Reilly logo

Writing Excel Macros with VBA, 2nd Edition by Steven Roman PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 19. 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

PivotItem

AddComment

FillLeft

PivotTable

AddIndent

FillRight

Precedents

Address

FillUp

PrefixCharacter

AddressLocal

Find

Previous

AdvancedFilter

FindNext

PrintOut

AllowEdit<v10>

FindPrevious

PrintPreview

Application

Font

QueryTable

ApplyNames

FormatConditions

Range

ApplyOutlineStyles

Formula

ReadingOrder

Areas

FormulaArray

RemoveSubtotal

AutoComplete

FormulaHidden

Replace

AutoFill

FormulaLabel

Resize

AutoFilter

FormulaLocal

Row

AutoFit

FormulaR1C1

RowDifferences

AutoFormat

FormulaR1C1Local

RowHeight

AutoOutline

FunctionWizard

Rows

BorderAround

GoalSeek

Run

Borders

Group

Select

Calculate

HasArray

SetPhonetic<v9>

Cells

HasFormula

Show

Characters

Height

ShowDependents

CheckSpelling

Hidden

ShowDetail

Clear

HorizontalAlignment

ShowErrors

ClearComments

Hyperlinks

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required