Range Object

         
Multiple objects
Range
Multiple objects

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

Using the Range Object

The following properties and methods return a Range object.

Object Properties/Methods
AutoFilter 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