Library.Range

This property returns the specified range from the top-most (visible) spreadsheet.

This property is read only.

Syntax Parameters Return Value
ReadOnly Property Library.Range( _
    Cells As Variant) As Range
Cells [in]

The range to return.

Type: Variant

Range

SVB Example

Selecting a range of cells in a spreadsheet:

Option Base 1
Option Explicit
Sub Main
    'Selects the designated ranges of cells
    Application.Range("C1R1:C3R3,C5R5:C6R6").Select
End Sub