Range Object

                  Properties         Methods        

Multiple objects
Range object
Multiple objects

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

Using the Range Object

The following properties and methods return a Range object.

The Pane object’s VisibleRange property

The Range object’s Cells property

The Range object’s Columns property

The Range object’s CurrentRegion property

The Range object’s EntireColumn property

The Range object’s EntireRow property

The Range object’s Find method

The Range object’s Item property

The Range object’s MergeArea property

The Range object’s Offset method

The Range object’s Range property

The Range object’s Rows property

The Spreadsheet object’s ActiveCell property

The Spreadsheet object’s Cells property

The Spreadsheet object’s Columns property

The Spreadsheet object’s Intersect method

The Spreadsheet object’s Range property

The Spreadsheet object’s Rows property

The Spreadsheet object’s Selection property

The Spreadsheet object’s Union method

The SpreadsheetEventInfo object’s Range property

The Worksheet object’s Cells property

The Worksheet object’s Columns property

The Worksheet object’s Range property

The Worksheet object’s Rows property

The Worksheet object’s UsedRange property

The Worksheet object’s VisibleRange property