This documentation is archived and is not being maintained.

Range Object


This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Aa190736.parchild(en-us,office.10).gifRange
Aa190736.space(en-us,office.10).gifAa190736.parchild(en-us,office.10).gif

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

Using the Range Object

The following properties and methods return a Range object.

ObjectProperties/Methods
AutoFilterRange
NameRefersToRange
Pane VisibleRange
Range Cells
Columns
CurrentArray
CurrentRegion
End
EntireColumn
EntireRow
Find
FindNext
FindPrevious
Item
MergeArea
Next
Offset
Previous
Range
Rows
SpreadsheetActiveCell
Cells
Columns
Range
RectIntersect
RectUnion
Rows
Selection
WindowActiveCell
RangeFromPoint
RangeSelection
Selection
VisibleRange
Worksheet Cells
Columns
Range
Rows
UsedRange

 

Show: