O'Reilly logo

Programming Excel with VBA and .NET by Steve Saunders, Jeff Webb

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

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

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