Range Object

Multiple objects Range Multiple objects

Represents a cell, a range of cells, a row, or a column.

Using the Range Object

The following properties and methods return a Range object.

Object	Properties/Methods
AutoFilter	Range
ListObject	DataBodyRange
	HeaderRowRange
	InsertRowRange
	Range
ListRow	Range
Name	RefersToRange
Pane	VisibleRange
Range	Cells
	Columns
	CurrentArray
	CurrentRegion
	End
	EntireColumn
	EntireRow
	Find
	FindNext
	FindPrevious
	Item
	MergeArea
	Next
	Offset
	Previous
	Range
	Rows
Spreadsheet	ActiveCell
	Cells
	Columns
	Range
	RectIntersect
	RectUnion
	Rows
	Selection
Window	ActiveCell
	RangeFromPoint
	RangeSelection
	Selection
	VisibleRange
Worksheet	Cells
	Columns
	Range
	Rows
	UsedRange