Range Members

Use the Range collection to work with cells on a worksheet. Use the Worksheet object’s Cells, Range, UsedRange, Columns, or Rows method to get a reference to this object. The Range collection has the following members. Key members (shown in bold) are covered in the following reference section:

Activate

AddComment

AddIndent

Address

AddressLocal

AdvancedFilter

AllowEdit

Application

ApplyNames

ApplyOutlineStyles

Areas

AutoComplete

AutoFill

AutoFilter

AutoFit

AutoFormat

AutoOutline

BorderAround

Borders

Calculate

Cells

Characters

CheckSpelling

Clear

ClearComments

ClearContents

ClearFormats

ClearNotes

ClearOutline

Column

ColumnDifferences

Columns

ColumnWidth

Comment

Consolidate

Copy

CopyFromRecordset

CopyPicture

Count

CreateNames

CreatePublisher

Creator

CurrentArray

CurrentRegion

Cut

DataSeries

Delete

Dependents

DialogBox

DirectDependents

DirectPrecedents

Dirty

End

EntireColumn

EntireRow

Errors

FillDown

FillLeft

FillRight

FillUp

Find

FindNext

FindPrevious

Font

FormatConditions

Formula

FormulaArray

FormulaHidden

FormulaLabel

FormulaLocal

FormulaR1C1

FormulaR1C1Local

FunctionWizard

GoalSeek

Group

HasArray

HasFormula

Height

Hidden

HorizontalAlignment

Hyperlinks

ID

IndentLevel

Insert

InsertIndent

Interior ...

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial