Application.Range

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

This property is read only.

Syntax	Parameters	Return Value
ReadOnly Property Application.Range( _ Cells As Variant) As Range	Cells [in] The range to return. Type: Variant	Range

Syntax

Parameters

Return Value

ReadOnly Property Application.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