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

Properties | Address Property | Application Property | Borders Property | Cells Property | Column Property | Columns Property | ColumnWidth Property | Count Property | CurrentArray Property | CurrentRegion Property | End Property | EntireColumn Property | EntireRow Property | Font Property | Formula Property | FormulaArray Property | FormulaLocal Property | HasArray Property | HasFormula Property | Height Property | Hidden Property | HorizontalAlignment Property | HTMLData Property | Hyperlink Property | Interior Property | Item Property | Left Property | ListObject Property | Locked Property | MergeArea Property | MergeCells Property | Name Property | Next Property | NumberFormat Property | Offset Property | Parent Property | PrefixCharacter Property | Previous Property | Range Property | ReadingOrder Property | Row Property | RowHeight Property | Rows Property | Text Property | Top Property | UseStandardHeight Property | UseStandardWidth Property | Value Property | Value2 Property | VerticalAlignment Property | Width Property | Worksheet Property

Methods | Activate Method | AutoFilter Method | AutoFit Method | BorderAround Method | Calculate Method | Clear Method | ClearContents Method | ClearFormats Method | Copy Method | CopyFromRecordset Method | Cut Method | Delete Method | FillDown Method | FillRight Method | Find Method | FindNext Method | FindPrevious Method | Insert Method | LoadText Method | Merge Method | ParseText Method | Paste Method | Select Method | Show Method | Sort Method | UnMerge Method | Validate Method

Events | Change Event

Parent Objects | AutoFilter Object | Border Object | Borders Collection | Hyperlink Object | ListObject Object | ListRow Object | Name Object | Pane Object | Range Object | Spreadsheet Object | Window Object | Worksheet Object

Child Objects | Borders Object | Font Object | Hyperlink Object | Interior Object | ListObject Object | Name Object | Range Object | Worksheet Object